把几个字段改成了 not null
ALTER TABLE snspaycenter
.t_paymethod
CHANGE COLUMN pm_alias
pm_alias
VARCHAR(60) CHARACTER SET UTF8 COLLATE utf8_general_ci NOT NULL DEFAULT _UTF8MB4’’ COMMENT ‘后台名称’;
ALTER TABLE snspaycenter
.t_paymethod
CHANGE COLUMN pm_show_name
pm_show_name
VARCHAR(60) CHARACTER SET UTF8 COLLATE utf8_general_ci NOT NULL DEFAULT _UTF8MB4’’ COMMENT ‘对外名称’;
在tidb执行错误提示
ERROR 1265 (01000): Data truncated for column ‘pm_show_name’ at row 1