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_MasterlistSETcontact_status=1 WHEREcontact=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_MasterlistWHEREcontact=8888' at line 1
Aucun commentaire:
Enregistrer un commentaire