w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
SQL syntax error on ON DUPLICATE KEY UPDATE

index is a SQL reserved words, you must rewrite your query

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)




© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.