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.

 

Next Post Previous Post
No Comment
Add Comment
comment url