mysql_select_db

mysql_select_db changes the default database on an active connection; the current default can also be queried with the SELECT DATABASE() SQL function.

Syntax

int mysql_select_db(MYSQL * mysql,
                    const char * db);

• mysql - a mysql handle, which was previously allocated by mysql_init() or mysql_real_connect().

• db - the default database name

Description

Selects a database as default. Returns zero on success, non-zero on failure

The SQL command SELECT DATABASE() will return the name of the default database.

The default database can also be set by the db parameter in mysql_real_connect().