SQL INSERT INTO


David Haertzen David Haertzen, Tutorial Author
Check out our
Data Warehousing Tutorial.
Previous | Next

SQL > SQL Basics > SQL INSERT INTO Statement


What is the SQL INSERT INTO Statement?

The SQL INSERT INTO statement is the SQL command that adds new rows to an SQL table.

Why Use the SQL INSERT INTO Statement?

Anytime you want to add new rows to an SQL table. For example, if you need to have another product in the product table, then you would use the INSERT statement to insert that product.

How To Use the SQL INSERT INTO Statement

The SQL INSERT command is used as follows.

SQL INSERT Statement Syntax

 
INSERT INTO <table_name> ( <column_list> )
VALUES (<value_list>)
 

INSERT INTO Statement Example 1

The following example adds a new row into the product table. Before the INSERT takes place the folliwng information exists in the table:

product_nbrproduct_name
1001 SQL Tool Light
1002 SQL Tool Professional
1003 SQL Tool Enterprise

This INSERT INTO Statement is executed:

 
INSERT INTO product (product_nbr, product_name)
VALUES ('2001', 'Data Modeling Tool Professional')
 

Results from the execution of the INSERT INTO statement are:

product_nbrproduct_name
1001 SQL Tool Light
1002 SQL Tool Professional
1003 SQL Tool Enterprise
2001 Data Modeling Tool Professional

Copyright© 1999-2015, First Place Software, Inc.