Help Center/ Distributed Database Middleware/ User Guide (Kuala Lumpur Region)/ FAQs/ SQL Syntax/ What Should I Do If an Error Is Reported When Multiple Data Records Are Inserted into Batches Using the INSERT Statement?
Updated on 2022-08-17 GMT+08:00

What Should I Do If an Error Is Reported When Multiple Data Records Are Inserted into Batches Using the INSERT Statement?

Solution

Split the INSERT statement into multiple small statements, or configure parameters on the console, modify the value of max_allowed_packet, and restart the instance to have the modification take effect.