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 vote272 views1 answer
Oracle drop default value
SQL
1 vote288 views1 answer
Pentaho + pasar de excel a sql
SQL
0 vote288 views1 answer
Shell script to log mysql cpu usage
SQL
2 votes298 views1 answer
Use cases condition in sql query laravel
SQL
0 vote333 views1 answer
Alternative for LIMIT sql
SQL
0 vote264 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote297 views2 answers
Py sqlite if entry exists
SQL
0 vote350 views1 answer
Compress sql file database ubuntu
SQL
1 vote301 views1 answer
Retrieve meaning
SQL
2 votes288 views1 answer
Get first 2 letter in sql
SQL