MySQL – Create Database

      No Comments on MySQL – Create Database

Database in MySQL can be created using CREATE DATABASE statement.

Syntax to create Database:

CREATE DATABASE databasename

e.g. to create database test , the below command can be issued

mysql> CREATE DATABASE test;

To view whether the database test got created or not, we can view the list of all databases by using show databases; command.

mysql> show databases;

This would list all databases in mysql.

Demo to explain create database in mysql