为了方便以后不再找mysql 的API,于是转了CSDN站内ID为loveu131的贴子。
Function | Description |
mysql_affected_rows() | Returns the number of rows changed/deleted/inserted by the last UPDATE , DELETE , or INSERT query. |
mysql_autocommit() | Toggles autocommit mode on/off. |
mysql_change_user() | Changes user and database on an open connection. |
mysql_close() | Closes a server connection. |
mysql_commit() | Commits the transaction. |
mysql_connect() | Connects to a MySQL server. This function is deprecated; use mysql_real_connect() instead. |
mysql_create_db() | Creates a database. This function is deprecated; use the SQL statement CREATE DATABASE instead. |
mysql_data_seek() | Seeks to an arbitrary row number in a query result set. |
mysql_debug() | Does a DBUG_PUSH with the given string. |
mysql_drop_db() | Drops a database. This function is deprecated; use the SQL statement DROP DATABASE instead. |
mysql_dump_debug_info() | Makes the server write debug information to the log. |
mysql_eof() | Determines whether the last row of a result set has been read. This function is deprecated; mysql_errno() or mysql_error() may be used instead. |
mysql_errno() | Returns the error number for the most recently invoked MySQL function. |
mysql_error() | Returns the error message for the most recently invoked MySQL function. |
mysql_escape_string() | Escapes special characters in a string for use in an SQL statement. |
mysql_fetch_field() | Returns the type of the next table field. |
mysql_fetch_field_direct() | Returns the type of a table field, given a field number. |
mysql_fetch_fields() | Returns an array of all field structures. |
mysql_fetch_lengths() | Returns the lengths of all columns in the current row. |
mysql_fetch_row() | Fetches the next row from the result set. |
mysql_field_seek() | Puts the column cursor on a specified column. |
mysql_field_count() | Returns the number of result columns for the most recent statement. |
mysql_field_tell() | Returns the position of the field cursor used for the last mysql_fetch_field() . |
mysql_free_result() | Frees memory used by a result set. |
mysql_get_client_info() | Returns client version information as a string. |
mysql_get_client_version() | Returns client version information as an integer. |
mysql_get_host_info() | Returns a string describing the connection. |
mysql_get_server_version() | Returns version number of server as an integer. |
mysql_get_proto_info() | Returns the protocol version used by the connection. |
mysql_get_server_info() | Returns the server version number. |
mysql_info() | Returns information about the most recently executed query. |
mysql_init() | Gets or initializes a MYSQL structure. |
mysql_insert_id() | Returns the ID generated for an AUTO_INCREMENT column by the previous query. |
mysql_kill() | Kills a given thread. |
mysql_library_end() | Finalize MySQL C API library. |
mysql_library_init() | Initialize MySQL C API library. |
mysql_list_dbs() | Returns database names matching a simple regular expression. |
mysql_list_fields() | Returns field names matching a simple regular expression. |
mysql_list_processes() | Returns a list of the current server threads. |
mysql_list_tables() | Returns table names matching a simple regular expression. |
mysql_more_results() | Checks whether any more results exist. |
mysql_next_result() | Returns/initiates the next result in multiple-statement executions. |
mysql_num_fields() | Returns the number of columns in a result set. |
mysql_num_rows() | Returns the number of rows in a result set. |
mysql_options() | Sets connect options for mysql_connect() . |
mysql_ping() | Checks whether the connection to the server is working, reconnecting as necessary. |
mysql_query() | Executes an SQL query specified as a null-terminated string. |
mysql_real_connect() | Connects to a MySQL server. |
mysql_real_escape_string() | Escapes special characters in a string for use in an SQL statement, taking into account the current character set of the connection. |
mysql_real_query() | Executes an SQL query specified as a counted string. |
mysql_refresh() | Flush or reset tables and caches. |
mysql_reload() | Tells the server to reload the grant tables. |
mysql_rollback() | Rolls back the transaction. |
mysql_row_seek() | Seeks to a row offset in a result set, using value returned from mysql_row_tell() . |
mysql_row_tell() | Returns the row cursor position. |
mysql_select_db() | Selects a database. |
mysql_server_end() | Finalize embedded server library. |
mysql_server_init() | Initialize embedded server library. |
mysql_set_local_infile_default() | Set the LOAD DATA LOCAL INFILE handler callbacks to their default values. |
mysql_set_local_infile_handler() | Install application-specific LOAD DATA LOCAL INFILE handler callbacks. |
mysql_set_server_option() | Sets an option for the connection (like multi-statements ). |
mysql_sqlstate() | Returns the SQLSTATE error code for the last error. |
mysql_shutdown() | Shuts down the database server. |
mysql_stat() | Returns the server status as a string. |
mysql_store_result() | Retrieves a complete result set to the client. |
mysql_thread_id() | Returns the current thread ID. |
mysql_thread_safe() | Returns 1 if the clients are compiled as thread-safe. |
mysql_use_result() | Initiates a row-by-row result set retrieval. |
mysql_warning_count() | Returns the warning count for the previous SQL statement. |