INSERT Statements

Explicit NULL is a Value

Explicit NULL is inserted as a visible value.

highlighted = computed this step

Explicit NULL is a value

A supplied NULL goes into that column; it does not ask for the default.

NULL is supplied\text{NULL is supplied}

Insert NULL note

The insert has 1 explicit NULL and still fills 1 omitted default.

explicit NULLs=1\text{explicit NULLs}=1

INSERT examples are tiny finite row appends; SQL dialect completeness, generated defaults, identity columns, constraints beyond visible NOT NULL, triggers, transactions, indexes, performance, and product behavior are out of scope.

Explicit NULL is a value: base rowsidnamestatusnote1Adaactiveseed2BennewNULL SchemacolumnnotNulldefaultidyesNO_DEFAULTnameyesNO_DEFAULTstatusyesnewnotenonone Column list to rowinsertcolumnsvaluesdecisionappendIndexreasons0(id, name, note)(3, Cy, NULL)accepted2() Resolved insert cellsinsertcolumnsupplieddefaultresultsourcereason0idyesNO_DEFAULT3explicitok0nameyesNO_DEFAULTCyexplicitok0statusnonewnewdefaultok0noteyesnoneNULLexplicit_NULLok Rows after INSERTidnamestatusnote1Adaactiveseed2BennewNULL3CynewNULL INSERT factsfactvaluebaseRowCount2insertAttemptCount1acceptedRowCount1rejectedRowCount0finalRowCount3defaultFillCount1explicitNullCount1

Read note

The note result is NULL because note was supplied explicitly.

NULL visible\text{NULL visible}

Summary

Explicit NULL and omitted column are different cases.

explicit versus omitted\text{explicit versus omitted}