Sunday, 25 October 2020

Python SQLITE3 - Referential Integrity-Update records with CASCADE, REST...

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