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 vote339 views1 answer
Create temporal table in sql
SQL
1 vote317 views1 answer
Oracle boolean to varchar
SQL
0 vote345 views1 answer
Copied text from internet not inserting in mysql
SQL
2 votes374 views2 answers
Mysql count rows returned
SQL
1 vote395 views1 answer
Sql server read uncommitted
SQL
0 vote341 views1 answer
Add timestamp column to existing table ms sql server
SQL
1 vote432 views2 answers
Coderbyte sql solutions
SQL
0 vote352 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote370 views1 answer
Ms sql filter all sympbol
SQL
0 vote317 views1 answer
Sql random decimal
SQL