SQL基础（六）- 删除

清空表数据：

mysql> select * from t_person;
+----------+------+---------+
| fname    | fage | fremark |
+----------+------+---------+
| Iurenl   |   25 | BlaBla  |
| Jim      |   22 | BlaBla  |
| Kimi     |   25 | BlaBla  |
| Lili     |   25 | BlaBla  |
| LXF      |   22 | BlaBla  |
| Tom      |   12 | Sonic   |
| XiaoWang |   25 | BlaBla  |
+----------+------+---------+
7 rows in set

mysql> select * from t_debt;
+---------+---------+---------+
| fnumber | famount | fperson |
+---------+---------+---------+
| 1       | 200     | Lili    |
| 2       | 300     | Jim     |
| 8       | 199.99  | Tom     |
+---------+---------+---------+
3 rows in set

mysql> delete from t_debt;
Query OK, 3 rows affected

mysql> delete from t_person;
Query OK, 7 rows affected

mysql> select * from t_debt;
Empty set

mysql> select * from t_person;
Empty set

mysql> show tables;
+--------------------+
| Tables_in_learnsql |
+--------------------+
| t_debt             |
| t_person           |
+--------------------+
2 rows in set

插入数据：

mysql> INSERT INTO T_Person(FName,FAge,FRemark) VALUES('Jim',20,'USA');
INSERT INTO T_Person(FName,FAge,FRemark) VALUES('Lili',22,'China') ;
INSERT INTO T_Person(FName,FAge,FRemark) VALUES('XiaoWang',17,' China ') ;
INSERT INTO T_Person(FName,FAge,FRemark) VALUES('Sam',16,'China') ;
INSERT INTO T_Person(FName,FAge,FRemark) VALUES('BlueFin',12,'Mars') ;
Query OK, 1 row affected

Query OK, 1 row affected

Query OK, 1 row affected

Query OK, 1 row affected

Query OK, 1 row affected

mysql> select * from t_person;
+----------+------+---------+
| fname    | fage | fremark |
+----------+------+---------+
| BlueFin  |   12 | Mars    |
| Jim      |   20 | USA     |
| Lili     |   22 | China   |
| Sam      |   16 | China   |
| XiaoWang |   17 |  China  |
+----------+------+---------+
5 rows in set

删除年龄大于20岁或者来自Mars的人员：

mysql> select * from t_person;
+----------+------+---------+
| fname    | fage | fremark |
+----------+------+---------+
| BlueFin  |   12 | Mars    |
| Jim      |   20 | USA     |
| Lili     |   22 | China   |
| Sam      |   16 | China   |
| XiaoWang |   17 |  China  |
+----------+------+---------+
5 rows in set

mysql> delete from t_person
    -> where fage>20 or fremark='Mars';
Query OK, 2 rows affected

mysql> select * from t_person;
+----------+------+---------+
| fname    | fage | fremark |
+----------+------+---------+
| Jim      |   20 | USA     |
| Sam      |   16 | China   |
| XiaoWang |   17 |  China  |
+----------+------+---------+
3 rows in set

删除表：

mysql> show tables;
+--------------------+
| Tables_in_learnsql |
+--------------------+
| t_debt             |
| t_person           |
+--------------------+
2 rows in set

mysql> drop table t_debt;
Query OK, 0 rows affected

mysql> drop table t_person;
Query OK, 0 rows affected

mysql> show tables;
Empty set