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 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:
This INSERT INTO Statement is executed:
Results from the execution of the INSERT INTO statement are: