Answer the question
In order to leave comments, you need to log in
Error while querying SQLite: "INSERT INTO VALUES" How to construct the query correctly?
There is a table lol with columns: Name - type "Char" and Count - type "Int"
I want to insert data into them with the following query:
INSERT INTO lol (Name, Count) VALUES ('Jarlo', 3)
Error:
no such column: Jarlo
For some reason, he thinks that Jarlo is a column, although it is data...
Maybe I didn't formulate the query correctly, if so, how should I compose such a query?
Answer the question
In order to leave comments, you need to log in
try replacing data type Name from Char to Text
CREATE TABLE lol (
Name TEXT,
Count INTEGER
) ;
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question