MySQL Creating, Showing, Selecting and Removing Databases

Creating Database





CREATE DATABASE [IF NOT EXISTS] database_name;



CREATE DATABASE test;




Showing Database
SHOW DATABASES;



+--------------------+

| Database                              |

+--------------------+

| information_schema |

| test               |

| mysql              |

+--------------------+

8 rows in set (0.00 sec)
 
Selecting Database
USE database_name;



USE test;




Removing Database
DROP DATABASE [IF EXISTS] database_name;




CREATE DATABASE IF NOT EXISTS temp_database;

SHOW DATABASES;

DROP DATABASE IF EXISTS temp_database;