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

9 votes246 views2 answers
Cmd to rename a collumn name in sql
SQL
12 votes264 views6 answers
Select distinct
SQL
0 vote278 views1 answer
Mysql add text to existing field
SQL
0 vote273 views1 answer
Sql update subtract value
SQL
0 vote266 views3 answers
Osx stop mysql service
SQL
0 vote256 views1 answer
Update sqlite
SQL
0 vote258 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote276 views1 answer
How to select all fieldsin a soql query
SQL
1 vote265 views1 answer
Select not matching data with join table
SQL
0 vote289 views2 answers
Wordpress change url after migration mysql query
SQL