How to insert data in a table in SQLite?

SQLite - Interview Questions

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);