ON DUPLICATE KEY UPDATE上的SQL语法错误

Question

I have this table that I want to update / insert with one statement currently using ON DUPLICATE KEY UPDATE:

index (INT) user(INT) entryId(INT) tags(text)
1              1          111      ||bla||
2              1          111      ||bla||
3              1          111      ||bla||

INSERT INTO filters (index,user,entryId,tags) VALUES (1,1,'100003817186741',"||test1||||test2||"), (3,1,'100003021196089',"||test1||||test2||") ON DUPLICATE KEY UPDATE user=VALUES(user),entryId=VALUES(entryId),tags=VALUES(tags)

Why does this fail with an SQL syntax error?

Answer 1

It fails because index is a MySQL reserved word.

http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

either wrap it in backticks or choose another word for it

INSERT INTO filters (index,user,entryId,tags)
                     ^    ^

do

INSERT INTO filters (`index`,user,entryId,tags)