Inserting records with SQL Lite

Question

What is the SQL Lite statement for "insert"?

I have tried

insert into table1 values(field1,field2) values (?,?)

but this returns an error in the statement -- how do I do this?

Answer 1

The correct syntax for the insert statement is here:

INSERT INTO table (column1, [column2, ... ]) VALUES (value1, [value2, ...])

Note that you have put the VALUES keyword before the list of column names.