我准备了
a fiddle which demonstrates the problem.
- CREATE TABLE parent (
- parent_id integer primary key
- );
- CREATE TABLE child (
- child_name TEXT primary key,parent_id integer REFERENCES parent (parent_id) ON DELETE CASCADE
- );
- INSERT INTO parent VALUES (1);
- INSERT INTO child VALUES ('michael',1),('vanessa',1);
我想要一种删除子记录时删除CASCADE到父记录的方法.
例如：
- DELETE FROM child WHERE child_name='michael';
这应该级联到父表并删除记录.
