Sqlite Parameterized insert query (escape)

Question

Hi I try to use SQLite Parameterized query but in the column name is a DOT (.)

INSERT INTO Data (`test.1`, `test.2`, `test.3`) VALUES (@test.1, @test.3,@test.3)

Returns

"SQL logic error or missing database near ".": syntax error"

INSERT INTO Data (`test.1`, `test.2`, `test.3`) VALUES ([@test.1], [@test.3],[@test.3])

Returns

"SQL logic error or missing database no such column: @test.1"

how can i escape the dot and still use the names as parameters!?

no i did not, let me check!!! did not work.. same error as second example. — Proxx
– Proxx, Commented Apr 8, 2015 at 11:25

Sai Kalyan Kumar Akshinthala · Accepted Answer · 2015-04-08 11:41:01Z

3

The "proper" escape character in SQLite is double quotes:

INSERT INTO Data("test.1", "test.2", "Test.3")
    VALUES ([@test1], [@test3], [@test3])

Leave the . out of the parameter name -- presumably, you have control over that.

SQLite explicitly supports the backtick for compatibility with MySQL and the square braces for compatibility with MS Access and SQL Server. (As you can see in the documentation.)

edited Apr 8, 2015 at 11:41

Sai Kalyan Kumar Akshinthala

11.9k8 gold badges45 silver badges68 bronze badges

answered Apr 8, 2015 at 11:34

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Proxx Over a year ago

oke whas hoping for a escaping solution. but i think this would be the best solution. now i do not need the brackets [ & ] anymore

Collectives™ on Stack Overflow

Sqlite Parameterized insert query (escape)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related