next up previous
Next: Updates Up: Modifying the Database Previous: Modifying the Database

Insertion

1. Insertion uses the I. operator.
2. To insert an account tuple for Smith:

   [画像:tabular331]

3. If values are missing, nulls are inserted.
4. To provide all loan customers in the SFU branch with a 200ドル savings account:

   [画像:tabular340]

   [画像:tabular348]

---

Osmar Zaiane
Tue Jun 9 14:17:04 PDT 1998