2021-04-10
閱讀量:
2686
Mysql報(bào)錯Error Code: 1262. Row 2 was truncated; it contained more data than there were inputcolumns
問:
Mysql報(bào)錯Error Code: 1262. Row 2 was truncated; it contained more data than there were inputcolumns
答:
這是因?yàn)閷?dǎo)入的數(shù)據(jù)字段數(shù)與表設(shè)置的字符安數(shù)不一致,另外,當(dāng)數(shù)據(jù)中含有轉(zhuǎn)義字符加空字符或換行符等特殊字符時,可能會因轉(zhuǎn)義問題出現(xiàn)此報(bào)錯;解決方法是修改mysql的sql_mode為空,語句為:set sql_mode='';






評論(0)


暫無數(shù)據(jù)
推薦帖子
0條評論
0條評論
0條評論
0條評論