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