UPDATE permissions
SET name = (
CASE WHEN IFNULL(name, '') = ''
THEN ''
ELSE name
END
) WHERE name IS NULL;
MySQL 数据库中如何将表字段的空值全部替换成空字符串
关注
打赏
UPDATE permissions
SET name = (
CASE WHEN IFNULL(name, '') = ''
THEN ''
ELSE name
END
) WHERE name IS NULL;
微信扫码登录