Show, Create, Drop and Use Database

Use SHOW DATABASES; to find out what databases exist on server.

mysql> SHOW DATABASES;




CREATE DATABASE creates a database with the given name.

CREATE DATABASE menagerie2;




DROP DATABASE Syntax

DROP {DATABASE | SCHEMA} [IF EXISTS] db_name

DROP DATABASE drops all tables in the database and deletes the database.

It will remove it permanently.

DROP DATABASE menagerie2;



USE Syntax
USE database name;
USE, like QUIT, does not require a semicolon
(You can terminate such statements with a semicolon if you like; it does no harm.)
The USE statement is special in another way,
too: it must be given on a single line.

To open a Database type "USE database name".
Set the default (current) (USE) database.
mysql> USE test