Create Database in MySQL

MySQL CREATE DATABASE

To create a MySQL database, open the MySQL Command Line Client. The MySQL Command Line Client will appear with a mysql> prompt. Here you will have to write the already set password. Now the next step is the creation of the 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’ name in MySQL are case sensitive.

Example:

CREATE DATABASE students;

Explanation:
A new database will be created with the name ‘students’. In order to check all the created database, below query, should be executed.
SHOW DATABASES;

Please Share