Python SQLITE3 - Referential Integrity-Update records with CASCADE, RESTRICT, SET NULL/DEFAULT-Part8

preview_player
Показать описание
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

Рекомендации по теме
join shbcf.ru