samedi 2 juillet 2016

MariaDB error 1064 on UPDATE statement


I need some help here:

I run 2 queries separately on the same table and one yields an error, the other is ok. The only difference is the SET value. take a look:

UPDATE `CRM_Masterlist` SET `contact_status`=1 WHERE `contact`=8888

Result:

SQL query: UPDATE CRM_Masterlist SET contact_status=1 WHERE contact=8888 Matched rows: 0

Anyone has any idea?

UPDATE `CRM_Masterlist` SET `contact_status`=0 WHERE `contact`=8888

Result:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM CRM_Masterlist WHERE contact=8888' at line 1


Aucun commentaire:

Enregistrer un commentaire