INSERT Statements

Column List Maps Values

The INSERT column list maps values to named columns.

highlighted = computed this step

Column list maps values

The INSERT column list tells the compiler which value goes to which column.

columns map values\text{columns map values}

Map three values

The row is accepted 1 time and fills 1 omitted default.

accepted=1\text{accepted}=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.

Column list maps values: base rowsidnamestatusnote1Adaactiveseed2BennewNULL SchemacolumnnotNulldefaultidyesNO_DEFAULTnameyesNO_DEFAULTstatusyesnewnotenonone Column list to rowinsertcolumnsvaluesdecisionappendIndexreasons0(id, name, status)(3, Cy, active)accepted2() Resolved insert cellsinsertcolumnsupplieddefaultresultsourcereason0idyesNO_DEFAULT3explicitok0nameyesNO_DEFAULTCyexplicitok0statusyesnewactiveexplicitok0notenononenonedefaultok Rows after INSERTidnamestatusnote1Adaactiveseed2BennewNULL3Cyactivenone INSERT factsfactvaluebaseRowCount2insertAttemptCount1acceptedRowCount1rejectedRowCount0finalRowCount3defaultFillCount1explicitNullCount0

Read resolved cells

The resolved-cells table shows each output column and where its value came from.

cell sources\text{cell sources}

Summary

Values are not matched by position in the base table; they are matched by the INSERT column list.

named columns\text{named columns}