SQL Insert Command

This statement is used to insert a row of data in a table. All inserted values are enclosed using single quote strings. The syntax of this command is:

insert into tablename
(column1name,column2name...columnxname)
values (value1,value2...valuex); 

Example

insert into citylist
(name, state, population, zipcode)
values ('Argos', 'Indiana', '89', '46501');