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

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