30、MySQL-删除表

来源：互联网发布：淘宝怎么找同款宝贝编辑：程序博客网时间：2024/05/22 05:11

1、一次删除一张数据表

DROP TABLE tbl_name;

2、一次删除多张数据表

DROP TABLE tbl_name1,tbl_name2...

mysql> USE learndb1;
Database changed
mysql> SHOW TABLES;
+--------------------+
| Tables_in_learndb1 |
+--------------------+
| mulpk              |
| table1             |
| table2             |
| tabledate          |
| tabledatetime      |
| tableenum          |
| tableeset          |
| tablepk            |
| tableset           |
| tablestring        |
| tabletext          |
| tabletime          |
| tabletimestamp     |
| tableyear          |
| tablezhushi        |
| testalter          |
| testat             |
| testdf             |
| testnnull          |
| testnum            |
| testunique         |
| user               |
+--------------------+
22 rows in set (0.02 sec)

mysql> -- 删除一张表
mysql> DROP TABLE tablepk;
Query OK, 0 rows affected (0.12 sec)

mysql> -- 删除多张数据表
mysql> DROP TABLE table1,table2;
Query OK, 0 rows affected (0.13 sec)

mysql> SHOW TABLES;
+--------------------+
| Tables_in_learndb1 |
+--------------------+
| mulpk              |
| tabledate          |
| tabledatetime      |
| tableenum          |
| tableeset          |
| tableset           |
| tablestring        |
| tabletext          |
| tabletime          |
| tabletimestamp     |
| tableyear          |
| tablezhushi        |
| testalter          |
| testat             |
| testdf             |
| testnnull          |
| testnum            |
| testunique         |
| user               |
+--------------------+
19 rows in set (0.02 sec)

0 0