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 vote140 views1 answer
Sql table to store status
SQL
0 vote155 views1 answer
Mysql date + 1 day
SQL
4 votes183 views3 answers
Rename table column postgresql
SQL
0 vote181 views1 answer
Mysql change timestamp on update
SQL
-1 vote228 views3 answers
MAKE TABLE FIT in oracle sql
SQL
6 votes186 views2 answers
If not exists insert sql
SQL
0 vote196 views1 answer
Postgres populate table from another table
SQL
5 votes179 views1 answer
Ignore duplicate rows in sqlite
SQL
5 votes185 views1 answer
Ora-00054 find lock
SQL
18 votes177 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL