Getting no such column error for values to be inserted
(1) By anonymous on 2020-08-31 07:27:04 [link] [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 [source]
Thanks, it seems to work now :D Really appreciate your help