SQLITE escape comment "--"

204 Views Asked by At

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

0

There are 0 best solutions below