MYSQL CREATE DATABASE Statement

Creating a Database

Before doing anything with the information we should need to make a database first. We're expecting that you as of now have a MySQL, or SQL Server accessible for your utilization, just as you've all the fundamental benefits, if not please look at the beginning aide. 

The SQL CREATE DATABASE explanation is utilized to make a database. 

Syntax

The  syntax for creating a database in Mysql :

CREATE DATABASE database_name;

The following SQL statement creates a database named demo:

CREATE DATABASE demo;

CREATE DATABASE makes a database with the given name. To utilize this announcement, you need the CREATE benefit for the database. Make SCHEMA is an equivalent for CREATE DATABASE. 

A mistake happens if the database exists and you didn't determine IF NOT EXISTS. 

CREATE  DATABASE isn't allowed inside a meeting that has a functioning LOCK TABLES explanation.

the USE demo; command sets the demo as target database demo for all future instrictions or commandes.

if you want to improve the solution

comment to help the community