Mysql命令-以NULL做where条件过滤时应该写 IS NULL;
以NULL做where条件过滤时应该写 IS NULL;
SELECT * FROM pet WHERE death IS NULL;
SELECT * FROM pet WHERE death IS NOT NULL;
注意别加引号。
转载请注明原处
以NULL做where条件过滤时应该写 IS NULL;
SELECT * FROM pet WHERE death IS NULL;
SELECT * FROM pet WHERE death IS NOT NULL;
注意别加引号。