Adding new rows to database table

We created the table, define the constraints and now they are ready to be populated with data.  INSERT command is used to populate the table with records.  Here is a statement that adds a row or record to product table.  This type of statement needs all the columns to be exact order.  This is a poor way to insert values into a table

INSERT INTO product VALUES('10000000', 'Printer', 'Inkjet colour Printer', '120', '80');

 

Here is a more favorable and controllable way to insert values into the a table.

INSERT INTO product (product_id, name, description, price, cost) VALUES ('10000000','Printer', Inkjet colour printer','120','80');