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 vote107 views1 answer
Mysql to get column name in database
SQL
4 votes103 views1 answer
Add constraint fk
SQL
7 votes113 views2 answers
3rd height salary sql
SQL
0 vote102 views1 answer
Foreign key type uniqu mysql
SQL
15 votes111 views6 answers
Laravel db transaction
SQL
0 vote102 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote87 views1 answer
Call procedure in wordpress
SQL
0 vote100 views1 answer
Mysql select all table that have field names
SQL
0 vote108 views1 answer
Pl/ sql change currency
SQL
1 vote102 views2 answers
Sql for date greater than
SQL