MySQL Error 1064 - Am I blind? Strange error [closed]
开发者_开发知识库
This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.
Closed 8 years ago.
Improve this questionMy query:
UDPATE message_recipients SET
recipient_status = 2 WHERE mid = 3 AND
recipient_id = 4
Table fields:
id, mid, recipient_status, recipient_id
Error:
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 'UDPATE message_recipients SET recipient_status = 2 WHERE mid = 3 AND recipient_i' at line 1
Could someone give me any advice?
You need UPDATE
instead of UDPATE
. I do this myself at least three times a week :)
精彩评论