-- if you want to insert values in all column -- values must be assigned to that column INSERT INTO table_name VALUES (value1, value2, value3, ...); -- ^ ^ ^ ^ -- (column1, column2, column3, ...) -- the same arrangement