Informix Guide to SQL: Tutorial
Chapter 4: Modifying Data
Home
Contents
Index
Master Index
New Book
Modifying Data
Statements That Modify Data
Deleting Rows
Deleting All Rows of a Table
Deleting a Known Number of Rows
Deleting an Unknown Number of Rows
Complicated Delete Conditions
Inserting Rows
Single Rows
Multiple Rows and Expressions
Restrictions on the Insert-Selection
Updating Rows
Selecting Rows to Update
Updating with Uniform Values
Impossible Updates
Updating with Selected Values
Database Privileges
Displaying Table Privileges
Data Integrity
Entity Integrity
Semantic Integrity
Referential Integrity
Using the ON DELETE CASCADE Option
Object Modes and Violation Detection
SQL Statements and Examples
Interrupted Modifications
The Transaction
Transaction Logging
Logging and Cascading Deletes
Specifying Transactions
Backups and Logs
Backing Up with INFORMIX-Universal Server
Concurrency and Locks
Data Replication
INFORMIX-Universal Server Data Replication
Summary
Informix Guide to SQL: Tutorial
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
