2011年11月10日星期四

how to delete mysql database through shell command

If you want to delete a database from mysql through shell command , to follow by the following steps.

mysql>
mysql> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| phpmyadmin         |
| test               |
| zhiwu              |
+--------------------+
5 rows in set (0.06 sec)

mysql> drop database test;
Query OK, 1 row affected (0.03 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| phpmyadmin         |
| zhiwu              |
+--------------------+
4 rows in set (0.00 sec)

mysql>

没有评论:

发表评论