Mysql报错Error Code: 1262. Row 2 was truncated; it contained more data than there were inputcolumns_CDA答疑社区

热线电话：13121318867

登录

詹惠儿

2021-04-10 阅读量: 2585

Mysql报错Error Code: 1262. Row 2 was truncated; it contained more data than there were inputcolumns

问：

Mysql报错Error Code: 1262. Row 2 was truncated; it contained more data than there were inputcolumns

答：

这是因为导入的数据字段数与表设置的字符安数不一致，另外，当数据中含有转义字符加空字符或换行符等特殊字符时，可能会因转义问题出现此报错；解决方法是修改mysql的sql_mode为空，语句为：set sql_mode='';

133.3333

1

0

关注作者

收藏

评论(0)

发表评论

暂无数据

CDA考试动态

CDA报考指南

推荐帖子