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 vote207 views1 answer
Sql transact create cursor with dynamic tables
SQL
10 votes224 views6 answers
Mysql delete duplicates
SQL
0 vote215 views1 answer
Sql counter column
SQL
1 vote217 views3 answers
Psql fatal database does not exist
SQL
0 vote224 views1 answer
Openquery update linked server
SQL
1 vote209 views1 answer
Sql bitwise operators
SQL
24 votes228 views4 answers
Mysql datetime
SQL
0 vote228 views1 answer
Sql join on a subquery
SQL
0 vote250 views1 answer
How to define a non primary composite key in sql
SQL
0 vote223 views1 answer
Mysql drop vs delete
SQL