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

1 vote135 views1 answer
Sql select table header
SQL
0 vote131 views1 answer
Sql select most frequent value in column
SQL
0 vote128 views1 answer
Show the colums of table sql
SQL
-1 vote136 views4 answers
Restart mysql server ubuntu
SQL
0 vote177 views1 answer
Updating database in sql
SQL
-1 vote137 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote185 views1 answer
TSQL Find csv file in folder
SQL
0 vote143 views1 answer
Is not numeric sql
SQL
0 vote138 views1 answer
Mysql average from two table
SQL
22 votes141 views3 answers
Year format in date mysql
SQL