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 vote114 views2 answers
How to update date in oracle
SQL
5 votes118 views1 answer
Postgres integer to serial
SQL
3 votes113 views2 answers
WhereIn SQL
SQL
2 votes112 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote116 views1 answer
Sql count null values in all columns
SQL
3 votes148 views2 answers
Check data in table mysql
SQL
1 vote127 views2 answers
Oracle create synonym
SQL
1 vote89 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
8 votes125 views3 answers
Postgresql connection string c#
SQL
0 vote121 views1 answer
Add computed column to table sql server
SQL