YouTip

# SQLite INSERT Statement SQLite's **INSERT INTO** statement is used to add new data rows to a table in the database. ## Syntax The INSERT INTO statement has two basic syntaxes, as shown below: INSERT INTO TABLE_NAME [(column1, column2, column3,...columnN)] VALUES (value1, value2, value3,...valueN); Here, column1, column2,...columnN are the names of the columns in the table into which you want to insert data. If you want to add values for all the columns in the table, you do not need to specify the column names in the SQLite query. However, you must ensure the order of the values matches the order of the columns in the table. The SQLite INSERT INTO syntax is as follows: INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN); ## Example Assume you have already created the COMPANY table in the testDB.db database, as shown below: sqlite> CREATE TABLE COMPANY( ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, AGE INT NOT NULL, ADDRESS CHAR(50), SALARY REAL ); Now, the following statements will create six records in the COMPANY table: INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1, 'Paul', 32, 'California', 20000.00 ); INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (2, 'Allen', 25, 'Texas', 15000.00 ); INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (3, 'Teddy', 23, 'Norway', 20000.00 ); INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00 ); INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (5, 'David', 27, 'Texas', 85000.00 ); INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (6, 'Kim', 22, 'South-Hall', 45000.00 ); You can also use the second syntax to create a record in the COMPANY table, as shown below: INSERT INTO COMPANY VALUES (7, 'James', 24, 'Houston', 10000.00 ); All the above statements will create the following records in the COMPANY table. The next chapter will teach you how to display all these records from a table. ID NAME AGE ADDRESS SALARY ---------- ---------- ---------- ---------- ----------1 Paul 32 California 20000.02 Allen 25 Texas 15000.03 Teddy 23 Norway 20000.04 Mark 25 Rich-Mond 65000.05 David 27 Texas 85000.06 Kim 22 South-Hall 45000.07 James 24 Houston 10000.0 ## Using One Table to Populate Another You can populate data into another table by using a SELECT statement on a table with a set of fields. The syntax is as follows: INSERT INTO first_table_name [(column1, column2, ... columnN)] SELECT column1, column2, ...columnN FROM second_table_name ; You can skip the above statement for now and first learn about the SELECT and WHERE clauses introduced in later chapters.