Question

How to insert data in a table in SQLite?

Answer 1

INSERT INTO statement is used to insert data in a table in SQLite database. There are two ways to insert data in table:

Method1:

Syntax:

INSERT INTO TABLE_NAME [(column1, column2, column3,...columnN)]      

VALUES (value1, value2, value3,...valueN);   

Method2:

Syntax:

INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN);