MySQL Error 1064 - Am I Blind? Strange mistake

My request:

UDPATE message_recipients SET recipient_status = 2 WHERE mid = 3 AND recipient_id = 4 

Table Fields:

id, mid, recipient_status, recipient_id

Mistake:

1064 - You have an error in the SQL syntax; check the manual that matches your MySQL server version for the correct syntax to use next to UDPATE message_recipients SET recipient_status = 2 WHERE mid = 3 AND recipient_i 'on line 1

Can anyone give me any advice?

+8
sql mysql sql-update
source share
1 answer

You need UPDATE instead of UDPATE . I do it myself at least three times a week :)

+15
source share

All Articles