数据库 导入 比较多的数据 报错。
1 mysql 导入比较多的数据时。修改一下内存。
-- 会话级调整（立即生效，重启失效）SET GLOBAL max_allowed_packet=1024*1024*1024; -- 设置为1024MB
2 修改sql node
(0 row(s) affected)
Execution Time : 00:00:00:062
Transfer Time : 00:00:00:000
Total Time : 00:00:00:062
(13867 row(s) affected)
Execution Time : 00:00:03:198
Transfer Time : 00:00:00:015
Total Time : 00:00:03:213
错误码: 1231
Variable 'sql_mode' can't be set to the value of 'NULL'
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
错误码: 1231
Variable 'foreign_key_checks' can't be set to the value of 'NULL'
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
错误码: 1231
Variable 'unique_checks' can't be set to the value of 'NULL'
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
错误码: 1231
Variable 'sql_notes' can't be set to the value of 'NULL'
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
修改sqlmode就行了。
参考文章，https://java456.com/blog/42
站长微信:xiaomao0055
站长QQ:14496453