24.删除表名

DROP [TEMPORARY] TABLE [IF EXISTS]
 tbl_name [, tbl_name] ...
[RESTRICT | CASCADE]
实例:
mysql> use oldboy;
Database changed
mysql> show tables;
+------------------+
| Tables_in_oldboy |
+------------------+
| zhangxuan |
+------------------+
1 row in set (0.00 sec)
mysql> drop table zhangxuan;
Query OK, 0 rows affected (0.06 sec)
mysql> show tables;
Empty set (0.00 sec)​
原文地址:https://www.cnblogs.com/hackerlin/p/12540024.html