# mysql\_select\_db

## Syntax

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

* `mysql` - a mysql handle, which was previously allocated by [mysql\_init()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_init) or [mysql\_real\_connect()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_real_connect).
* `db` - the default database name

## Description

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

{% hint style="info" %}
The SQL command [SELECT DATABASE()](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/secondary-functions/information-functions/database) will return the name of the default database.

The default database can also be set by the db parameter in [mysql\_real\_connect()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_real_connect).
{% endhint %}

{% @marketo/form formId="4316" %}