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 vote127 views1 answer
Rermove categories woocommerce sql
SQL
0 vote120 views1 answer
Select the date 30 days less that the todays date sql request
SQL
0 vote113 views1 answer
Recover deleted data from mysql database
SQL
4 votes112 views1 answer
Sql any
SQL
0 vote109 views1 answer
Json not contains mysql
SQL
1 vote111 views1 answer
Alphabetical order mysql
SQL
0 vote124 views1 answer
One table with another
SQL
0 vote128 views2 answers
Nodejs mysql convert to plain object
SQL
1 vote103 views1 answer
Can not connect to mysql server
SQL
0 vote107 views1 answer
Mysql use password error
SQL