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

14 votes294 views5 answers
Set password for postgres user ubuntu
SQL
0 vote248 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote271 views1 answer
Check command
SQL
2 votes253 views1 answer
Oracle sql concatenate results into string
SQL
2 votes249 views2 answers
Laravel query builder toSql
SQL
16 votes259 views1 answer
Sql comment'
SQL
0 vote257 views1 answer
Oracle c# multiple update sql
SQL
5 votes240 views6 answers
Sql add days to date
SQL
1 vote256 views1 answer
Psql lst trigger
SQL
42 votes319 views6 answers
Sql query duplicate rows
SQL