SQL Insert Into

The INSERT INTO statement is used to insert a value into the table in SQL.

Here is the syntax to INSERT INTO

Insert into table_name

Values (column1,column2,…);

The order of specifying the value is essential.

Insert into table_name (column1,column2,column3,…)

Values (column1,column2,column3…);

The following example inserts a value into a table

Insert into EMPLOYEES

Values(101,’Neena’,’Kochhar’,108);

Insert into EMPLOYEES (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,MANAGER_ID)

Values(101,’Neena’,’Kochhar’,108);

EMPLOYEE_ID	FIRST_NAME	LAST_NAME	MANAGER_ID
101	Neena	Kochhar	108