We need a database, and in order to create a database you need to use the following syntax.

CREATE A NEW DATABASE NAME CALLED MYDB


CREATE DATABASE IF NOT EXISTS mydb;

After executing the statement, MySQL will returns you a message to notify the new database created successfully or not.

Showing all the databases from your MySQL Server

SHOW DATABASES;

DISPLAY



0 comments:

Post a Comment

 
Top
Blogger Template