Loading...

The insert into statement is used to insert new record(s) in a table. If we are adding values in the columns of table we need to specify column name and that's values to be insert. 

Example of Insert Query with specifying columns name.

insert into TableName (column1, column2, column3) 
values (value1, value2, value3)


If we are inserting values for all the columns then we don't need to specify all the column's name in SQL statement. But, we have to make sure that order of columns and order of its values should be same. 

Example of Insert Query without specifying columns name.

insert into TableName 
values (value1. value2, value3)