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

6 votes222 views4 answers
Mysql group by date
SQL
0 vote209 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote213 views1 answer
Selecting from a view SQL
SQL
0 vote199 views1 answer
Contraint default SQL
SQL
0 vote215 views1 answer
Datagrip execute procedure
SQL
5 votes193 views2 answers
Update all rows mysql
SQL
0 vote217 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
5 votes206 views1 answer
Mysql count newlines in field
SQL
1 vote228 views1 answer
Oracle sql pad left zeros
SQL
0 vote212 views1 answer
Open postgresql.conf in centos
SQL