Consider an employees table consisting of only 3 fields on the order name, location, and salary, then a record can be entered in the employee's table using the INSERT command. The 2 ways we can do this are –  a. Method 1 – Mention column values in the right order  INSERT INTO employees
VALUES (‘John Doe’, ‘Indore’, 1000000); b. Method 2 – Mention both the column names and column. Here the order is referred from the query itself.  INSERT INTO employees (name, location, salary)
VALUES (‘John Doe’, ‘Indore’, 1000000);