Python - How to use Sqlite3 database (Referential Integrity - How to update records from parent table with CASCADE, RESTRICT, SET NULL, SET DEFAULT, NO ACTION) -Part8
This part covers -
1. Update records from parent table
2. How to control updation of records from parent table with options like
- CASCADE,
- SET NULL,
- SET DEFAULT,
- NO ACTION
- RESTRICT
3. How combine ON DELETE & ON UPDATE operation to override default behavior for referential integrity
4. Topic for future videos - Next part will be on creating TRIGGERS
No comments:
Post a Comment