sqldatabasesqlitesql-insertparse-error

SQLite insert issue – Error: no such column

I faced an issue with SQLite (version 3.7.13 if matters).

I created a new table with two columns foo and bar, data type is undefined. When I try to insert numbers, it works fine. But when I insert text, Error: no such column happens.

sqlite> CREATE TABLE test (foo, bar);
sqlite> .tables
test
sqlite> insert into test values (0,1);
sqlite> select * from test;
0|1
sqlite> insert into test values (a,b);
Error: no such column: a

What am I doing wrong?

Thanks.

Solution

  • You need to quote strings

    insert into test values('a', 'b')