SQLite INSERT INTO SQLite statement

Using the INSERT INTO statement in SQLite you can insert values into a database table. An example is provided below:

INSERT INTO suppliers(name)
VALUES
	("Farmer Joe"),
	("Trader Bernt");

Above SQLite INSERT INTO statement inserts two entries into the name column of the suppliers table. The syntax applied is the following:

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

If values are inserted into all columns of the table, the columns must not be listed explicitly. In that case the syntax looks like this:

INSERT INTO table
VALUES( value1,	value2 ,...);