on update cascade
CREATE TABLE child (
id INT,
parent_id INT,
INDEX par_ind (parent_id),
FOREIGN KEY (parent_id)
REFERENCES parent(id)
ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=INNODB;
5
1
CREATE TABLE child (
id INT,
parent_id INT,
INDEX par_ind (parent_id),
FOREIGN KEY (parent_id)
REFERENCES parent(id)
ON UPDATE CASCADE
) ENGINE=INNODB;
Thank you!
1
5
(1 Votes)
0
Are there any code examples left?
New code examples in category SQL
Relative searches
on delete on update cascade
sql update cascade query
cascade On Delete vs >on Delete('cascade');
update cascade
CASCADE DELETE
sqlalchemy on delete cascade
mysql cascade update
update cascade meaning
on delete cascade in sql
delete and update on cascade
alter constraint cascade delete
on delete set cascade
on cascade delete
on delete cascade meaning
on update cascade ensures which of the following
on update cascade vs on delete cascade
on delete cascade
what does on update cascade do
on update cascade
cascade on update
sql on delete cascade
on delete cascade sql
on delete cascade in sql
update sql with cascade
update on delete cascade mysql
