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.34 mysql_list_fields()
MYSQL_RES *mysql_list_fields(MYSQL *mysql, const char *table, const char *wild)
Description
Returns a result set consisting of field names in the given table that match
the simple regular expression specified by the wild parameter.
wild may contain the wildcard characters `%' or `_', or may
be a NULL pointer to match all fields. Calling
mysql_list_fields() is similar to executing the query SHOW
COLUMNS FROM tbl_name [LIKE wild].
Note that it's recommended that you use SHOW COLUMNS FROM tbl_name
instead of mysql_list_fields().
You must free the result set with mysql_free_result().
Return Values
A MYSQL_RES result set for success. NULL 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.
User Comments
| Posted by [name withheld] on Monday July 21 2003, @9:12am | [Delete] [Edit] |
While I understand the theory of why it's suggested to us "SHOW COLUMNS" over mysql_list_fields, I wouldn't suggest it. The "SHOW COLUMNS" leaves with a result set that you have to parse and interpret, while mysql_list_fields will give you access to the MYSQL_FIELD structures (which of course then lend to all of the flag comparisons as well as definition types).
