INSERT Statements

Row Appends to the End

Accepted rows append after existing rows.

highlighted = computed this step

Row appends to the end

An accepted row is added after the existing source rows.

append row\text{append row}

Read append index

The final table has 3 rows, and the appended row index is 2.

final rows=3\text{final rows}=3

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.

Row appends to the end: 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 after table

The new row appears at the bottom of this finite display.

end of table\text{end of table}

Summary

This book uses deterministic append order.

append order\text{append order}