Insert

LastName	FirstName	Address	City
ABC	EFG	1,First St	Chicago
XYZ	EFG	3,Second St	New York

LastName	FirstName	Address	City
ABC	EFG	1,First St	Chicago
XYZ	EFG	3,Second St	New York
EFG	ABC	2,Third St	Indianapolis

INSERT

The INSERT statement is used to insert new rows into a
table.
The syntax of the INSERT statement is

INSERT INTO <table name> VALUES (<value1,
value2...>)

One can specify the columns for which data needs to
be inserted.

Consider the following table:

Student

The following query inserts a new row into the
Student table

INSERT INTO Student VALUES ('EFG', 'ABC', '2, Third
St', 'Indianapolis')

SQL Queries