vendredi 22 juillet 2016

What is wrong with this small query? SQL errors

I have this Query:

INSERT INTO abilities_usage (id, name, usage) 
      VALUES 
("5467", "naga_siren_mirror_image", "1") 
ON DUPLICATE KEY UPDATE id='5467';

SQL response:

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 'usage) VALUES ("5467", "naga_siren_mirror_image", "1") ON DUPLICATE KEY UPDATE i' at line 1

Why?

Aucun commentaire:

Enregistrer un commentaire