SQL - INSERT Query

The SQL INSERT query is used to insert a new record into the table. We can add a new record to the table in two ways.

INSERT Query Syntax :

The syntax of the INSERT Query statement is −

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

Here column1, column2, column3, ... columnN is the name of the column and the value1, value2, value3, ... valueN is the value of the corresponding column.

We do not have to specify by column name, if you are adding values for all the columns of the table.
NOTE:- Value should be in same order as the columns in the table.

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

Consider the Customer table with the following records -

TEST CASE 1 :- The following code is an example, which would add new record to Customer table.

INSERT INTO Customer (CustomerName, Address, CustomerSalary)
VALUES ('Sarthak', 'Delhi', '31000');

The result for the respective sql query is as follows −

TEST CASE 2:- The following code is an example, which would add new record to Customer table.

INSERT INTO Customer 
VALUES ('Rushil', 24, 'Indore', 20000);

The result for the respective sql query is as follows −

Visit :

Discussion