Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 45 of 79

MySQL SQL Revision Tour — Question 13

Back to all questions
13
Question

Question 13

When a column's value is skipped in an INSERT command, which value is inserted in the database ?

Answer

The columns that are not listed in the INSERT command will have their default value, if it is defined for them, otherwise, NULL value. If any other column (that does not have a default value and is defined NOT NULL) is skipped or omitted, an error message is generated and the row is not added.