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 vote167 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote140 views1 answer
Sql put two columns into one
SQL
0 vote162 views1 answer
Suhaib
SQL
2 votes200 views2 answers
How to DROP a table in mysql
SQL
13 votes129 views4 answers
Mysql get last row
SQL
-1 vote135 views1 answer
Auto increment psql not primary key
SQL
15 votes140 views2 answers
Select where duplicate mysql
SQL
13 votes149 views4 answers
Command line mysql import
SQL
0 vote156 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote281 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL