删除数据 —— DELECT
删除所有数据
DELECT FROM 表名;
实例1
- 题目:删除new_goods表中的所有数据
1.选择数据库。
mysql> USE db_shop;
Database changed
2.删除所有数据。
mysql> DELETE FROM new_goods;
Query OK, 6 rows affected (0.02 sec)
3.查询数据表
mysql> SELECT*FROM new_goods;
Empty set (0.00 sec)
删除指定数据
DELETE FROM 表名 WHERE 限定范围的条件;
实例2
- 题目:删除表中id>3的记录。
1.选择数据库
mysql> USE db_shop;
Database changed
2.删除指定数据
mysql> DELETE FROM goods WHERE id>3;
Query OK, 3 rows affected (0.02 sec)
3.查询数据表
mysql> SELECT*FROM goods;
+----+--------+--------------+-------+------+---------------------+
| id | type | name | price | num | add_time |
+----+--------+--------------+-------+------+---------------------+
| 1 | 书籍 | 斗罗大陆 | 38.50 | 0 | 2022-02-12 15:30:27 |
| 2 | 水果 | 火龙果 | 15.00 | 0 | 2022-03-06 14:12:32 |
| 3 | 蔬菜 | 胡萝卜 | 6.00 | 0 | NULL |
+----+--------+--------------+-------+------+---------------------+
3 rows in set (0.00 sec)