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

2 votes118 views1 answer
Sql server find table name
SQL
0 vote124 views2 answers
Check mysql timezone
SQL
4 votes160 views1 answer
Mysql query first character
SQL
0 vote131 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
1 vote114 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
1 vote146 views1 answer
Nvl postgres
SQL
3 votes134 views1 answer
Insert into table from another table mysql
SQL
6 votes137 views2 answers
Sql query to get the number of rows in a table
SQL
1 vote143 views1 answer
Mysql strict_trans_tables
SQL
-2 votes179 views3 answers
How to fetch first 10 rows in sql
SQL