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 vote365 views1 answer
Hashpass
SQL
2 votes334 views1 answer
Oracle run_duration average
SQL
1 vote324 views1 answer
Select if then postgresql
SQL
0 vote343 views1 answer
Sql gather statistics to increase performance
SQL
1 vote325 views1 answer
How do you use sql in you company
SQL
5 votes345 views1 answer
Sql add column after another
SQL
0 vote330 views1 answer
Mysql where in keep order
SQL
1 vote334 views1 answer
Alphabetical order mysql
SQL
0 vote318 views1 answer
Postgresql print variable
SQL
3 votes329 views2 answers
Enter mysql command line
SQL