PHP中的MySQL函数

大多数MySQL函数把连接信息做为最后一个参数。如果不提供该参数，就使用最后一个打开的连接。如果没有和数据库建立任何连接，将会试图使用php.ini中默认的参数。如果操作失败，函数将会返回FALSE。

mysql_affected_rows — 获得在之前的MySQL操作中受到影响的行数
mysql_change_user — 改变当前连接中登陆的用户
mysql_client_encoding — 返回字符类型
mysql_close — 关闭MySQL连接
mysql_connect — 打开一个到MySQL服务器的连接
mysql_create_db — 建立一个MySQL数据库
mysql_data_seek — Move internal result pointer
mysql_db_name — Get result data
mysql_db_query — 发送一个MySQL查询
mysql_drop_db — 删除一个MySQL数据库
mysql_errno — Returns the numerical value of the error message from previous MySQL operation
mysql_error — Returns the text of the error message from previous MySQL operation
mysql_escape_string — Escapes a string for use in a mysql_query
mysql_fetch_array — Fetch a result row as an associative array, a numeric array, or both
mysql_fetch_assoc — Fetch a result row as an associative array
mysql_fetch_field — Get column information from a result and return as an object
mysql_fetch_lengths — Get the length of each output in a result
mysql_fetch_object — Fetch a result row as an object
mysql_fetch_row — Get a result row as an enumerated array
mysql_field_flags — Get the flags associated with the specified field in a result
mysql_field_len — Returns the length of the specified field
mysql_field_name — Get the name of the specified field in a result
mysql_field_seek — Set result pointer to a specified field offset
mysql_field_table — Get name of the table the specified field is in
mysql_field_type — Get the type of the specified field in a result
mysql_free_result — Free result memory
mysql_get_client_info — Get MySQL client info
mysql_get_host_info — Get MySQL host info
mysql_get_proto_info — Get MySQL protocol info
mysql_get_server_info — Get MySQL server info
mysql_info — Get information about the most recent query
mysql_insert_id — Get the ID generated from the previous INSERT operation
mysql_list_dbs — List databases available on a MySQL server
mysql_list_fields — List MySQL table fields
mysql_list_processes — List MySQL processes
mysql_list_tables — List tables in a MySQL database
mysql_num_fields — Get number of fields in result
mysql_num_rows — 获得查询结果的行数
mysql_pconnect — Open a persistent connection to a MySQL server
mysql_ping — Ping a server connection or reconnect if there is no connection
mysql_query — 执行sql语句
mysql_real_escape_string — Escapes special characters in a string for use in a SQL statement
mysql_result — Get result data
mysql_select_db — Select a MySQL database
mysql_set_charset — Sets the client character set
mysql_stat — Get current system status
mysql_tablename — Get table name of field
mysql_thread_id — Return the current thread ID
mysql_unbuffered_query — Send an SQL query to MySQL, without fetching and buffering the result rows

原文：http://www.php.net/manual/en/ref.mysql.php

Related Posts

1. mysql_data_seek
2. mysql_num_rows
3. mysql_db_name
4. mysql_db_query
5. mysql_connect
6. mysql_errno
7. mysql_error
8. mysql_query
9. HDFS安装与使用
10. Error Codes 错误代码

Tags: MySQL.