MySQL使用DELETE语句删除数据表中不需要的数据记录

MySQL使用DELETE语句删除数据表中不需要的数据记录

DELETE语句用来删除数据表中的一条或多条数据记录。

格式：

DELETE FROM 表名 [WHERE 条件][ORDER BY 字段][LIMIT 行数]

-- 删除
--=======================================
mysql> delete from stu where id=200;
Query OK, 0 rows affected (0.02 sec)

mysql> delete from stu where age>=40 and age<=50;
Query OK, 0 rows affected (0.00 sec)

mysql> update stu set age=12 where id=15;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from stu;
+----+----------+-----+-----+---------+
| id | name     | age | sex | classid |
+----+----------+-----+-----+---------+
|  1 | zhangsan |  20 | m   | lamp110 |
|  2 | lisi     |  22 | w   | lamp110 |
|  3 | wangwu   |  28 | m   | lamp106 |
|  4 | zhaoliu  |  31 | m   | lamp110 |
|  5 | xiaowang |  18 | w   | lamp111 |
|  6 | laowang  |  38 | m   | lamp106 |
|  7 | xiaoli   |  28 | w   | lamp110 |
|  8 | uu01     |  21 | w   | lamp110 |
|  9 | uu02     |  25 | m   | lamp110 |
| 10 | uu03     |  25 | m   | lamp106 |
| 11 | uu04     |  27 | m   | lamp111 |
| 12 | uu05     |  32 | w   | lamp110 |
| 13 | uu06     |  27 | m   | lamp111 |
| 14 | uu07     |  24 | w   | lamp106 |
| 15 | uu08     |  12 | m   | lamp110 |
+----+----------+-----+-----+---------+
15 rows in set (0.00 sec)

欢迎转载，转载需注明地址： http://www.luowebs.com/Skill_desc/32/488.html

很赞哦！ (0)