I'm using DB Browser for SQLite, doing multiple inserts. However I need to escape -- but it just keeps giving me errors.
INSERT INTO table(name) VALUES ("S6--sfI6H6E"),("ASGts7sa6jw") -- Error at S6
I have tried the following:
INSERT INTO table(name) VALUES ("S6\-\-sfI6H6E"),("ASGts7sa6jw") ESCAPE '\' - Error at ESCAPE
INSERT INTO table(name) VALUES ("S6\-\-sfI6H6E"),("ASGts7sa6jw") - Inserts Literal String
INSERT INTO table(name) VALUES ("S6'-'-sfI6H6E"),("ASGts7sa6jw") - Inserts Literal String
INSERT INTO table(name) VALUES ("S6----sfI6H6E"),("ASGts7sa6jw") - Error at S6
How can I escape --?