ERROR 1406 (22001): Data too long for column 'name_' at row 1
ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'foreign_key_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'unique_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'sql_notes' can't be set to the value of 'NULL'
原因时导入文件过大,需要修改允许的最大值:
- 查看最大值
show variables like 'max_allowed_packet';
- 修改最大值
set global max_allowed_packet = 200 * 1024 * 1024; (200M)
- 退出mysql重新登录