Question

SQL语句如何删除字段记录不等于"123456"的所有记录

比如我的表叫A表 字段叫BB 我现在想删除字段BB中不等于'123456'的所有记录 如何写？

Answer 1

有两种写法
一种：delete from A where bb<>123456
二种：delete from A where bb!=123456
两种方法就是不等号不同而已

Answer 2

--1，先查询记录，防止误删
select * from A表 T
where T.BB='123456'
--2，发现时你要删除的数据后，执行删除操作
delete from A表 T
where T.BB<>'123456'

Answer 3

dele from A where bb!='123456'
绝对正常！

Answer 4

delete from A表
where A表.BB<>'123456'

Answer 5

delete A
where bb not in (select bb from A where bb='123456')