MySQL Manual
9 MySQL APIs
- 9.1 MySQL C API
- 9.1.3 C API Function Descriptions
- 9.1.3.1
mysql_affected_rows() - 9.1.3.2
mysql_change_user() - 9.1.3.3
mysql_character_set_name() - 9.1.3.4
mysql_close() - 9.1.3.5
mysql_connect() - 9.1.3.6
mysql_create_db() - 9.1.3.7
mysql_data_seek() - 9.1.3.8
mysql_debug() - 9.1.3.9
mysql_drop_db() - 9.1.3.10
mysql_dump_debug_info() - 9.1.3.11
mysql_eof() - 9.1.3.12
mysql_errno() - 9.1.3.13
mysql_error() - 9.1.3.14
mysql_escape_string() - 9.1.3.15
mysql_fetch_field() - 9.1.3.16
mysql_fetch_fields() - 9.1.3.17
mysql_fetch_field_direct() - 9.1.3.18
mysql_fetch_lengths() - 9.1.3.19
mysql_fetch_row() - 9.1.3.20
mysql_field_count() - 9.1.3.21
mysql_field_seek() - 9.1.3.22
mysql_field_tell() - 9.1.3.23
mysql_free_result() - 9.1.3.24
mysql_get_client_info() - 9.1.3.25
mysql_get_server_version() - 9.1.3.26
mysql_get_host_info() - 9.1.3.27
mysql_get_proto_info() - 9.1.3.28
mysql_get_server_info() - 9.1.3.29
mysql_info() - 9.1.3.30
mysql_init() - 9.1.3.31
mysql_insert_id() - 9.1.3.32
mysql_kill() - 9.1.3.33
mysql_list_dbs() - 9.1.3.34
mysql_list_fields() - 9.1.3.35
mysql_list_processes() - 9.1.3.36
mysql_list_tables() - 9.1.3.37
mysql_num_fields() - 9.1.3.38
mysql_num_rows() - 9.1.3.39
mysql_options() - 9.1.3.40
mysql_ping() - 9.1.3.41
mysql_query() - 9.1.3.42
mysql_real_connect() - 9.1.3.43
mysql_real_escape_string() - 9.1.3.44
mysql_real_query() - 9.1.3.45
mysql_reload() - 9.1.3.46
mysql_row_seek() - 9.1.3.47
mysql_row_tell() - 9.1.3.48
mysql_select_db() - 9.1.3.49
mysql_sqlstate() - 9.1.3.50
mysql_shutdown() - 9.1.3.51
mysql_stat() - 9.1.3.52
mysql_store_result() - 9.1.3.53
mysql_thread_id() - 9.1.3.54
mysql_use_result() - 9.1.3.55
mysql_commit() - 9.1.3.56
mysql_rollback() - 9.1.3.57
mysql_autocommit() - 9.1.3.58
mysql_more_results() - 9.1.3.59
mysql_next_result()
- 9.1.3.1
9.1.3.41 mysql_query()
int mysql_query(MYSQL *mysql, const char *query)
Description
Executes the SQL query pointed to by the null-terminated string query.
The query must consist of a single SQL statement. You should not add
a terminating semicolon (`;') or \g to the statement.
mysql_query() cannot be used for queries that contain binary data; you
should use mysql_real_query() instead. (Binary data may contain the
`\0' character, which mysql_query() interprets as the end of the
query string.)
If you want to know if the query should return a result set or not, you can
use mysql_field_count() to check for this.
See section 9.1.3.20 mysql_field_count().
Return Values
Zero if the query was successful. Non-zero if an error occurred.
Errors
CR_COMMANDS_OUT_OF_SYNC- Commands were executed in an improper order.
CR_SERVER_GONE_ERROR- The MySQL server has gone away.
CR_SERVER_LOST- The connection to the server was lost during the query.
CR_UNKNOWN_ERROR- An unknown error occurred.
