开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜