郑维勇的博客

1、删除单条数据

Delete from tb_student12 where 姓名='孙秀斌'

２、删除多行数据

Delete from tb_grade12 where 课程号='01'

3、删除所有数据

Delete from tb_student12

注意:与Drop table table_name命令的区别

4、删除部份重复的行

Delete from tb_deleteALL12 where 编号 not in

(

select max(编号) as 编号 from tb_deleteAll12 group by 姓名

)

5、使用子查询删除数据

Delete from tb_test12

where 学号 in

(

Select 学号

from tb_grade12

where tb_test12.学号=tb_Grade12.学号 and

tb_test12.课程号=tb_Grade12.课程号

)