SQL error #1064
Trying t开发者_高级运维o enter a value into a mediumblob field in a mySQL table but I'm getting:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id = 40' at line 3
INSERT INTO 'Picture'
VALUES (efvr)
WHERE id = 40
What's wrong with this statement, and how can it be fixed?
You can't have a WHERE clause on an INSERT. If you're trying to change an existing row, you need to use an UPDATE instead.
精彩评论