Create/Drop/List mysql database

Create Database

SYNTAX

Create database < database_name>
Ex:
 mysql> Create database sqlnosql ;
 Query OK, 1 row affected (1.29 sec)

List Database (List  of all databases present)

SYNTAX

show databases; 

Drop Database

SYNTAX

Dropdatabase < database_name>
Ex:

mysql> drop database sqlnosql;
Query OK, 0 rows affected (0.07 sec)

 

Leave a Reply

Your email address will not be published. Required fields are marked *