MySQL :: MySQL 8.4 C API Developer Guide :: 5.4.46 mysql_list_dbs() (original) (raw)

5.4.46 mysql_list_dbs()

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

Description

Returns a result set consisting of database names on the server 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 databases. Callingmysql_list_dbs() is similar to executing the query SHOW DATABASES [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_OUT_OF_MEMORY
  Out of memory.
• 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.