Help Center> Distributed Database Middleware> FAQ> SQL Syntax> What Should I Do If an Error Is Reported When Multiple Data Records Are Inserted into Batches Using the INSERT Statement?

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.