MYSQL批量插入记录异常的处理方法
问题:mysql批量插入10W条记录,异常:
### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (32,164,587 > 4,194,304). You can change this value on the server by setting the 'max_allowed_packet' variable..
原创
2020-05-14 11:29:17 ·
1206 阅读 ·
0 评论