当前位置：首页 → 问答吧 → 怎么删除查询出来的反向数据？

怎么删除查询出来的反向数据？

时间：2011-10-20

来源：互联网

sqlstr:='select * from TempPljxKx where (Pzh like ''%'+EdtSearch.text+'%'' or bz like ''%'+EdtSearch.text+'%'')';

我用上面的模糊查询语句可以查出想要的数据，那么我要将其他没有查询出来的数据删除要怎么写呢？

作者: yangqi613 发布时间: 2011-10-20

sqlstr := 'delete from temppljxkx where id not in (select id from TempPljxKx where (Pzh like ''%'+EdtSearch.text+'%'' or bz like ''%'+EdtSearch.text+'%''))'

作者: bdmh 发布时间: 2011-10-20

sqlstr:='delete from TempPljxKx where not ((Pzh like ''%'+EdtSearch.text+'%'' or bz like ''%'+EdtSearch.text+'%''))';

作者: SmallHand 发布时间: 2011-10-20

Delphi(Pascal) code

sqlstr:='delete from TempPljxKx where not (Pzh like ''%'+EdtSearch.text+'%'' or bz like ''%'+EdtSearch.text+'%'')';

作者: SmallHand 发布时间: 2011-10-20

Delphi(Pascal) code

sqlstr:='delete from TempPljxKx where not (Pzh like ''%'+EdtSearch.text+'%'' or bz like ''%'+EdtSearch.text+'%'')';

作者: SmallHand 发布时间: 2011-10-20

引用 1 楼 bdmh 的回复:
sqlstr := 'delete from temppljxkx where id not in (select id from TempPljxKx where (Pzh like ''%'+EdtSearch.text+'%'' or bz like ''%'+EdtSearch.text+'%''))'

这个是标准的。。

作者: babydog01 发布时间: 2011-10-20

sqlstr:='select * from TempPljxKx where (Pzh not like ''%'+EdtSearch.text+'%'' or bz not like ''%'+EdtSearch.text+'%'')';

作者: hxmxzhang 发布时间: 2011-10-20

sqlstr:='Delete from TempPljxKx where (Pzh not like ''%'+EdtSearch.text+'%'' or bz not like ''%'+EdtSearch.text+'%'')';

作者: hxmxzhang 发布时间: 2011-10-20