SQL INSERT INTO Statement

The INSERT INTO statement is used to insert a new row in a table


SQL INSERT INTO Syntax
It is possible to write the INSERT INTO statement in tow forms


*The first form doesn't specify the column names where the data will be inserted, only their values:
INSERT INTO table_name
VALUES (value1, value2, value3,........)


*The second form specifies both the column names and the values to be inserted:
INSERT INTO table_name (column1, column2, column3,.....)
VALUES (value1, value2, value3,.......)


**Numeric value should be given as it is and Text value should be given as 'value'