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>
没有评论:
发表评论