2021-04-10
閱讀量:
2623
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
答:
這是因為導入的數(shù)據(jù)字段數(shù)與表設置的字符安數(shù)不一致,另外,當數(shù)據(jù)中含有轉義字符加空字符或換行符等特殊字符時,可能會因轉義問題出現(xiàn)此報錯;解決方法是修改mysql的sql_mode為空,語句為:set sql_mode='';






評論(0)


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