开发者

SQL error #1064

开发者 https://www.devze.com 2023-01-20 10:37 出处:网络
Trying t开发者_高级运维o enter a value into a mediumblob field in a mySQL table but I\'m getting:

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

精彩评论

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

关注公众号