How to create MySQL Create Database??
You can create a MySQL database by using MySQL Command Line Client.
Open the MySQL console and write down password, if you set one while installation. You will get the following:
Now you are ready to create database.
Syntax:
CREATE DATABASE database_name;
Example:
Let's take an example to create a database name "employees"
CREATE DATABASE employees;
It will look like this:
You can check the created database by the following query:
SHOW DATABASES;
Output
Here, you can see the all created databases.
Note: All the database names, table names and table fields name are case sensitive. You must have to use proper names while giving any SQL command.