MySQL数据库对数据库的操作(二)

2014-11-24 17:36:48 · 作者: · 浏览: 2
------+--------+------+------------+---------+
| t | 1 | in_tong | 1 | a | A | | | | YES | BTREE | |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
[root@localhost ~]#


13.用mysqladmin删除数据库
[root@localhost ~]# mysqladmin drop tongcheng -u root -p
Enter password:
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.

Do you really want to drop the 'tongcheng' database [y/N] y
Database "tongcheng" dropped
[root@localhost ~]#


14.用mysqladmin关闭数据库
[root@localhost ~]# mysqladmin -u root -p shutdown
Enter password:
[root@localhost ~]#