insert into nulltest(name,sex) values (null,null); delete from nulltest where name=null and sex=null; 结果:Query OK,0 rows affected
你的SQL不对啊,不是上面写了么,不能用=,应该是 delete from nulltest where name is null and sex is null;
一般不用=null的,null是个关键字,用它的时候都是用 is null 或 is not null,至少我没过=null的 如果你这样插入:insert into nulltest(name,sex) values ('null','null'); 那么你删除的时候就应该: delete from nulltest where name='null' and sex='null';
按问题中的方法插入后,可以光根据根据name的值来进行类似操作吗?
**********返回结果:删除了0行*********
你们可以试试看
delete from nulltest where name=null and sex=null;
结果:Query OK,0 rows affected
delete from nulltest where name is null and sex is null;
如果你这样插入:insert into nulltest(name,sex) values ('null','null');
那么你删除的时候就应该:
delete from nulltest where name='null' and sex='null';