sql语句----删除表中行使用delete

最新推荐文章于 2023-09-04 07:45:00 发布

吉730

最新推荐文章于 2023-09-04 07:45:00 发布

阅读量2.4k

点赞数

文章标签： sql 数据库

本文链接：https://blog.csdn.net/weixin_69899223/article/details/125653039

版权

删除表中行  使用delete 
				
有筛选条件 仅删除符合条件的行 
delete   from  库.表  where  筛选条件；

没有筛选条件 删除表里所有行       
delete   from  库.表；

############################################
例子
mysql> select * from stu3;
+--------+--------+------+--------+
| number | name   | age  | gender |
+--------+--------+------+--------+
|      1 | jj     |   17 | boy    |
|      2 | ll     |   17 | boy    |
|      3 | qq     |   17 | girl   |
|     12 | qiuqiu |   17 | boy    |
|     15 | lili   |   17 | boy    |
|     17 | rourou |   17 | boy    |
|     16 | wuwu   |   17 | boy    |
|      1 | jj     |   17 | boy    |
|   NULL | ppqq   | NULL | NULL   |
+--------+--------+------+--------+
9 rows in set (0.00 sec)
mysql> select *  from stu3  where age is null;
+--------+------+------+--------+
| number | name | age  | gender |
+--------+------+------+--------+
|   NULL | ppqq | NULL | NULL   |
+--------+------+------+--------+
1 row in set (0.01 sec)

mysql>  delete   from stu3  where age is null;
Query OK, 1 row affected (0.00 sec)

mysql> select *  from stu3
    -> ;
+--------+--------+------+--------+
| number | name   | age  | gender |
+--------+--------+------+--------+
|      1 | jj     |   17 | boy    |
|      2 | ll     |   17 | boy    |
|      3 | qq     |   17 | girl   |
|     12 | qiuqiu |   17 | boy    |
|     15 | lili   |   17 | boy    |
|     17 | rourou |   17 | boy    |
|     16 | wuwu   |   17 | boy    |
|      1 | jj     |   17 | boy    |
+--------+--------+------+--------+
8 rows in set (0.00 sec)