UPDATE users
SET user_role = ‘-1’ where user_role is null;
UPDATE users
SET iswork = 1 where iswork is null;
UPDATE users
SET workTime = ‘1544500525984’ where workTime is null;
SELECT * FROM users
where user_role is null;
sql为空的判断
最新推荐文章于 2023-12-29 17:52:08 发布