The INSER statement needs to specify column names unless the values that are being inserted are for columns that are primary keys only one row is being inserted into the table the values are inserted in the same order as the table's columns multiple rows are being inserted into the table with a single statement