Insert query in MySql

INSERT used for add new records in a table.

Syntax

1)-INSERT INTO tablename(column1,column2,column3,...)values(values1,values2,values3,...)

2)-INSERT INTO tablename SET column1=values1,column2=values2,column3=values3,...

3)-INSERT INTO tablename values(values1,values2,values3,...)