2022-08-26 sql update 对null字段无

不要写成
UPDATE pdd SET fafangzhuangtai = 1 WHERE fafangzhuangtai=0;
或者
UPDATE pdd SET fafangzhuangtai = 1 WHERE fafangzhuangtai=null;

要写成下面这样的

UPDATE pdd SET fafangzhuangtai = 1 WHERE fafangzhuangtai IS NULL;