On update cascade

Cascade delete on update

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;

Source: qastack.id

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
) ENGINE=INNODB;

-1

Source: qastack.id

Similar codes

0 vote384 views1 answer
SQL Cut part string
SQL
17 votes361 views4 answers
Postgres list users
SQL
0 vote412 views1 answer
Remove mysql from centos 7
SQL
0 vote431 views1 answer
Mysql get longest string in column
SQL
0 vote350 views1 answer
In mysql workbench contnent not feching
SQL
0 vote336 views1 answer
Order by ip address sql
SQL
1 vote350 views1 answer
Drop df constraint sql server
SQL
0 vote448 views1 answer
Drop table BigQuery table columns
SQL
5 votes364 views3 answers
Mysql remove unique constraint
SQL
11 votes368 views1 answer
Oracle view source
SQL