U3F1ZWV6ZTc5OTgzNDMxMzE1MzJfRnJlZTUwNDYwNDY0NzA3Nzc=

MYSQL CREATE DATABASE Statement

MYSQL CREATE DATABASE Statement,create mysql databae,mysql database


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
Comments
No comments
Post a Comment

Post a Comment

NameEmailMessage