MySQL - CREATE DATABASE Statement

In MySQL, the CREATE DATABASE statement is used to create a new database. Here's the basic syntax:

CREATE DATABASE your_database_name;

Replace your_database_name with the name you want to give to your new database. Here's an example:

CREATE DATABASE my_database;

This statement creates a new database named your_database. Make sure to have the necessary privileges to execute this statement, usually, you need the CREATE privilege for the database.

You can also specify additional options while creating a database, such as character set and collation:

CREATE DATABASE your_database 
  CHARACTER SET utf8mb4
  COLLATE utf8mb4_unicode_ci;

This example creates a database named your_database with the character set utf8mb4 and collation utf8mb4_unicode_ci. Adjust these options according to your requirements.

If you use the IF NOT EXISTS clause along with the CREATE statement as shown below a new database will be created and if a database with the given name, already exists the query will be ignored database.

CREATE DATABASE IF NOT EXISTS myDatabase

Recommended Laravel Posts For You:

Recommended: MySQL join Queries With example?

Recommended: MySQL - Set Foreign Key Constraint (Enable/Disable)