CREATE DATABASE

The CREATE DATABASE statement is used to create new database in MySQL. by using this Database we can store data in table consist database.

Basic Syntax as follow:

CREATE DATABASE databaseName

Syntax For MySQL:

CREATE DATABASE Company

After Execute:
(1 row(s) affected)
(0 ms taken)

-- Create only if it does not exists

CREATE DATABASE IF NOT EXISTS databaseName

-- Show the CREATE DATABASE statement 

SHOW CREATE DATABASE databaseName

SELECT DATABASE();