mysql 空字符串转成NULL,防止枚举类型映射到枚举报错
mysql 空字符串转成NULL,防止枚举类型映射到枚举报错
IF(LENGTH(name)=0,NULL,name)
示例:
select t.id, IF(LENGTH(t.mode)=0,NULL,t.mode) from user t
WHERE t.sys_user_id = 'ca86bc200d8b4b3c9a9d42221e3b9a45';
IF(LENGTH(name)=0,NULL,name)
select t.id, IF(LENGTH(t.mode)=0,NULL,t.mode) from user t
WHERE t.sys_user_id = 'ca86bc200d8b4b3c9a9d42221e3b9a45';