CREATE DATABASE in MySQL

by

CREATE DATABASE in MySQL
To create a MySQL database, open the MySQL Command Line Client. The MySQL Command Line Client will appear with a mysql> prompt. Write the already set password, and you are ready to create a MySQL database.

Syntax:

CREATE DATABASE name;

Parameters:
name: It is used to specify the name of the database to be created. The database name, table name, and table fields’ names in MySQL are case-sensitive.

Example: 

CREATE DATABASE stores;

Explanation:
A new database with the name ‘stores’ will be created in MySQL. All the existing databases can be checked using the below query.
SHOW DATABASES;