MySQL Tutorial MySQL Advanced MySQL Database Account Management MySQL References

MySQL CREATE DATABASE Keyword



The MySQL CREATE DATABASE keyword is used to create a new MySQL database.

Syntax

The syntax of using CREATE DATABASE statement in MySQL is given below:

CREATE DATABASE DatabaseName;

Please note that to create any database, appropriate privilege is required. Along with this, the database name should be unique within the RDBMS. After creating the database, the following command can be used to see the list of databases available in RDBMS.

SHOW DATABASES;

Example: create a database

To create a database with name testDB, the following statement can be used:

CREATE DATABASE testDB;

After creating the database, the SHOW DATABASES; command can be used to see the list of databases available in RDBMS.

mysql> SHOW DATABASES;
Result:
+-------------+
| Database    |
+-------------+
| SQLExample1 |
| SQLExample2 |
| SQLExample3 |
| SQLExample4 |
| SQLExample5 |
| SQLExample6 |
| SQLExample7 |
| SQLExample8 |
| testDB      |
+-------------+
9 rows in set (0.00 sec)

❮ MySQL Keywords