Javatpoint Logo
Javatpoint Logo

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:

mysql create database

Now you are ready to create database.

Syntax:

Example:

Let's take an example to create a database name "employees"

It will look like this:

mysql create database

You can check the created database by the following query:

Output

mysql create database

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.






Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA