If data is only being added to some of the columns in a table,the names of the columns must be listed in the VALUES clause.

Question

If data is only being added to some of the columns in a table,the names of the columns must be listed in the VALUES clause.​

Quizplus · Accepted Answer

When only some columns are being added to in a SQL INSERT statement, the names of those columns must be listed in the INSERT INTO clause, not in the VALUES clause. The VALUES clause is used to specify the values to be inserted into the specified columns.

If Data Is Only Being Added to Some of the Columns