DELETE Statements

No Matching Rows

No TRUE rows means the table is unchanged.

highlighted = computed this step

No matching rows

If WHERE finds no TRUE rows, DELETE leaves the table unchanged.

no match\text{no match}

Try missing owner

The status is no_match, with 0 removed rows and 4 kept rows.

removed=0\text{removed}=0

DELETE examples are tiny finite row removals; SQL dialect completeness, joins in DELETE, subqueries, triggers, constraints, transactions, locks, indexes, optimizer behavior, performance, and product behavior are out of scope.

No matching rows: base rowsidownerstatuspoints1Adaopen102Benopen203Cydone154DeeNULL5 WHERE chooses rowssourcevaluecompareTotruthremoved0AdaNiaFALSEno1BenNiaFALSEno2CyNiaFALSEno3DeeNiaFALSEno Rows removedsourcerowreasonnonenonenone Rows after DELETEidownerstatuspoints1Adaopen102Benopen203Cydone154DeeNULL5 DELETE factsfactvaluebaseRowCount4removedRowCount0keptRowCount4finalRowCount4whereUnknownCount0deleteStatusno_matchwhereKindeq

Compare after rows

The after table matches the base table because no row was TRUE.

unchanged table\text{unchanged table}

Summary

No-match is still a computed DELETE result.

no hidden edit\text{no hidden edit}