mysql删除语句大全（上）drop delete turncate

1.drop语句。可以用来删除数据库和表。

A用drop语句来删除数据库：

 

mysql> drop database hello;
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)

 

B用drop语句来删除表：

 

mysql> drop table q1;
Query OK, 0 rows affected (0.39 sec)

mysql> show tables;
+------------------+
| Tables_in_trains |
+------------------+
| 4inall           |
| ava              |
| book             | <