In this article, we would like to show you how to create database in MySQL.
CREATE DATABASE `database_name`;
CREATE DATABASE example
In this example, we will create a new database -
CREATE DATABASE `diraskDB`;
CREATE DATABASE IF NOT EXISTS example
You can optionally add
IF NOT EXISTS statement, so if the database already exists you won't get an error.
CREATE DATABASE IF NOT EXISTS `diraskDB`;
CREATE SCHEMAis a synonym for
CREATE DATABASEso you can use it alternately.
If you try to create a database that already exists with
CREATE DATABASE query you will get an error:
If you try to
CREATE DATABASE IF NOT EXIST you will get a warning instead: