SQL INSERT QUERY


The SQL INSERT INTO Statement is used to add new rows of data to a table in the database.

Syntax:

INSERT INTO table_name [(column1, column2, column3,...columnN)]  
VALUES (value1, value2, value3,...valueN);

Example:

INSERT INTO book (bookid,bookname,bookprice)
 VALUES(1, 'html',102)

INSERT INTO book (bookid,bookname,bookprice)
 VALUES (2, 'css',120)
Output
bookidbooknamebookprice
1html102
2css120

Here, column1, column2,...columnN are the names of the columns in the table into which you want to insert data.

You may not need to specify the column(s) name in the SQL query if you are adding values for all the columns of the table. But make sure the order of the values is in the same order as the columns in the table.

The SQL INSERT INTO syntax would be as follows:

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

Example:

INSERT INTO book VALUES(1, 'html',102)

INSERT INTO book VALUES (2, 'css',120)
Output
bookidbooknamebookprice
1php122
2visual200

Populate one table using another table

You can populate data into a table through select statement over another table provided another table has a set of fields, which are required to populate first table.

Syntax

INSERT INTO first_table_name [(column1, column2, ... columnN)] 
   SELECT column1, column2, ...columnN 
   FROM second_table_name
   [WHERE condition];

Share this article on