MYSQL - Drop Database

How to Drop a Database in MySql
1. Open your terminal. 

2. Connect to MySql.If not use below link to know how to connect.

How to Connect to MySql Database using MAC terminal

3. Once you logged into your mysql then type the below command 
to drop a database (OMS is database name).

mysql> drop DATABASE OMS;

4. To check whether Database OMS dropped or not type below command.

mysql> USE OMS; ERROR 1049 (42000): Unknown database 'oms'

Which says Database 'OMS' no more exits.
***********Happy Learning*************

No comments:

Post a Comment

Featured Post

H1B Visa Stamping at US Consulate

  H1B Visa Stamping at US Consulate If you are outside of the US, you need to apply for US Visa at a US Consulate or a US Embassy and get H1...