DML statement-Insert

nInsert is used to insert a new row in a table

Syntax:

INSERT INTO table_name VALUES (value1, value2, value3,...)

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

Query:

INSERT INTO EMPtbl1 VALUES (‘Batista’, ‘IBM', ’90,000', ‘Bangalore')

INSERT INTO EMPtbl1 (EMPname, company, salary, Location)

VALUES (‘Batista’, ‘IBM', ’90,000', ‘Bangalore')