MySQL 删除数据库

SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | java505 | | mysql | | performance_schema | | sakila | | sys | | testjdbc | | world | +--------------------+ 8 rows in set (0.00 sec)

 

删除数据库

mysql> DROP DATABASE testjdbc;
Query OK, 3 rows affected (1.01 sec)

 

查看数据库

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| java505            |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| world              |
+--------------------+
7 rows in set (0.00 sec)

 

MySQL 删除数据库

标签：--   mysq   数据   sch   mys   com   test   databases   sql