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
-
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