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?