Create Database

 How to create a database?

Syntax:

CREATE DATABASE <Database Name>;

Example:

CREATE DATABASE SchoolDB;

Now you can open your MySQL Database Software are run the following command and create your own database.

For Reference how to do it see my video.



How to see the Databases in MySQL Server?

Syntax or Command is:     SHOW DATABASES;

This command will print the list of all the databases in MySQL Server.


How to change the working Database?


Syntax: USE <Database Name>;

Command: USE SchoolDB;