Getting no such column error for values to be inserted
(1) By anonymous on 2020-08-31 07:27:04
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]
I assume you want to insert a literal. In SQL, string literals have to be quoted with single quotes. ```sql INSERT INTO testTable VALUES ('lol'); ``` ~~~ -- Regards, Kees Nuyt ~~~
(3) By anonymous on 2020-09-01 08:28:36 in reply to 2 [link]
Thanks, it seems to work now :D Really appreciate your help