Insert Update Delete MySQL Tutorial

The basic syntax for the INSERT statement is as follows.

INSERT INTO 
VALUES (
value1,
value2,
etc......
);
The above format will work fine if you are inserting data into every field in a row.
If you only want to insert data into certain fields (columns) you will need to specify only these fields as part of the statement.

INSERT INTO  (
column1,
column2,
....
) VALUES (
value1,
value2,
....
);