|< < 32 > >|

Foreign keys and updates

CASCADE update

update P set p_id = 5 where p_id = 3;

P

p_id	x
1	123
2	456
3	789
4	111

F

f_id	p_id	y
1001	1	999
1002	1	888
2001	2	777
3001	3	666
3002	3	555
3003	3	444

→

P

p_id	x
1	123
2	456
4	111
5	789

F

f_id	p_id	y
1001	1	999
1002	1	888
2001	2	777
3001	5	666
3002	5	555
3003	5	444

|< < 32 > >|