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');