Codd's Twelve Rules - Rule 7 - High level Insert, Update, and Delete
Rule 7
|
High level Insert, Update, and Delete
|
Rule
|
The
capability of handling a base relation or a derived relation as a single
operand applies not only to the retrieval of data but also to the insertion,
update, and deletion of data.
|
Description
|
This
rule stresses the set-oriented nature of a relational database. It requires
that rows be treated as sets in insert, delete, and update operations. The
rule is designed to prohibit implementations that support only row-at-a-time,
navigational modification of the database. The SQL language covers this via
the INSERT, UPDATE, and DELETE statements.
|
Example
|
SQL Server, MySQL, and Oracle support bulk
insert, delete, and update.
INSERT INTO yourtable VALUES (1,2), (5,5), ...; - this
can be used to insert multiple rows at a time in MySQL.
|
Some DBMS that fulfills this property
|
SQL Server, MySQL, and Oracle
|