YouTipMysql Select Database
# MySQL Select Database
After you connect to a MySQL database, there might be multiple databases you can operate on, so you need to select the database you want to work with.
* * *
## Selecting a MySQL Database from the Command Prompt
In the mysql> prompt window, you can easily select a specific database.
In MySQL, to select the database you want to use, you can use the `USE` statement. The basic syntax is as follows:
```sql
USE database_name;
**Parameter Description:**
* **database_name** is the name of the database you want to select.
After selecting a database, your subsequent SQL queries and operations will be executed on the specified database **database_name**.
### Example
The following example selects the database :
[root@host]# mysql -u root -p
Enter password:******
mysql> use ;
Database changed
mysql>
After executing the above command, you have successfully selected the database, and all subsequent operations will be performed within the database.
From the command line, you can select a database using the following method:
mysql -u your_username -p -D your_database
* The `-D` parameter is used to specify the database to select.
For example:
mysql -u root -p -D
After entering the password, you will be at the MySQL prompt, and any subsequent queries and operations will be executed on the database.
> Please ensure the selected database exists, otherwise you will receive an error message. You can use `SHOW DATABASES;` to query available databases and ensure the database you want to select is in the list.
* * *
## Selecting a MySQL Database Using a PHP Script
PHP provides the function `mysqli_select_db` to select a database. The function returns `TRUE` on success, or `FALSE` on failure.
### Syntax
```php
mysqli_select_db(connection, dbname);
| Parameter | Description |
| --- | --- |
| _connection_ | Required. Specifies the MySQL connection to use. |
| _dbname_ | Required. Specifies the default database to use. |
### Example
The following example demonstrates how to use the `mysqli_select_db` function to select a database:
## Select Database
```php
[](#)(#)
(#)[](#)
(javascript:void(0);)
* [Python / Data Science](javascript:void(0);)
* [AI / Intelligent Development](javascript:void(0);)
")
* (javascript:void(0);)