以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;
注意别加引号。
转载于:https://www.cnblogs.com/xiaozong/p/5269840.html