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 --
?