问我如何删除第一条记录?
我用SQL语句如下,但却不行:
delete from table1 where A='aaa' and B=''
我把SQL语句改成这样,也不行:
delete from table1 where A='aaa' and B=NULL
如何解决?谢谢了
...全文
962打赏收藏
当要查的字段内容为空时,怎么查询?
如我有一个表table1,其中有两个字段:A和B, A,B字段联合起来唯一标识一条记录 表中有两条数据: A B aaa aaa bbb 问我如何删除第一条记录? 我用SQL语句如下,但却不行: delete from table1 where A='aaa' and B='' 我把SQL语句改成这样,也不行: delete from table1 where A='aaa' and B=NULL 如何解决?谢谢了