1.drop语句。可以用来删除数据库和表。
A用drop语句来删除数据库:
mysql> drop database hello;
Query OK, 0 rows affected (0.19 sec)
Query OK, 0 rows affected (0.19 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| test |
| trains |
+--------------------+
6 rows in set (0.00 sec)
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| test |
| trains |
+--------------------+
6 rows in set (0.00 sec)
B用drop语句来删除表:
mysql> drop table q1;
Query OK, 0 rows affected (0.39 sec)
Query OK, 0 rows affected (0.39 sec)
mysql> show tables;
+------------------+
| Tables_in_trains |
+------------------+
| 4inall |
| ava |
| book | <
+------------------+
| Tables_in_trains |
+------------------+
| 4inall |
| ava |
| book | <