MySQL :: MySQL 8.4 C API Developer Guide :: 5.4.49 mysql_list_tables() (original) (raw)

The world's most popular open source database

5.4.49 mysql_list_tables()

MYSQL_RES *
mysql_list_tables(MYSQL *mysql,
                  const char *wild)

Description

Returns a result set consisting of table names in the current database 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 tables. Callingmysql_list_tables() is similar to executing the query SHOW TABLES [LIKE_`wild`_].

You must free the result set withmysql_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.