Replies: 1 comment
-
Split it into much smaller batches. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I am trying to insert 50K records using the example here:
#2168 (comment)
But I am getting an error like this:
code: 'ER_PS_MANY_PARAM',
errno: 1390,
sqlState: 'HY000',
sqlMessage: 'Prepared statement contains too many placeholders',
Looks like this is a MySQL limitation and the limit is 65536. I have 14 placeholders so I can insert 4681 at once. What is the best way to insert more? Just split it and call connection.execute as many times I need?
Beta Was this translation helpful? Give feedback.
All reactions