Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

executeMany fails with UPDATE query #28

Open
timmyw opened this issue Feb 22, 2016 · 0 comments
Open

executeMany fails with UPDATE query #28

timmyw opened this issue Feb 22, 2016 · 0 comments

Comments

@timmyw
Copy link

timmyw commented Feb 22, 2016

executeMany expects a string VALUES (?,?,?...) in the query, which requires the underlying values() function (which is provided by PostgreSQL, but not MySQL). The regex used in the source for formatMany just looks for VALUES (?,?,?...) substring. A MySQL update would require it to support a query of the form UPDATE table SET x = ?, y = ? WHERE z = ?. MySQL doesn't support any way (that I could find) that would allow an update query that used the VALUES(?,?,?...) form. The documentation just needs changing to specify that executeMany only works with insert queries, and not update queries.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant