SQLite Forum

Getting no such column error for values to be inserted
Login

Getting no such column error for values to be inserted

(1) By anonymous on 2020-08-31 07:27:04 [source]

This is my input : insert into testTable values(lol) This is the error : error no such column : lol I am using it through termux rn and I am really confused about this

(2) By Kees Nuyt (knu) on 2020-08-31 09:21:59 in reply to 1 [link] [source]

I assume you want to insert a literal.

In SQL, string literals have to be quoted with single quotes.

INSERT INTO testTable VALUES ('lol');
-- 
Regards,
Kees Nuyt

(3) By anonymous on 2020-09-01 08:28:36 in reply to 2 [link] [source]

Thanks, it seems to work now :D Really appreciate your help