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

4 votes232 views4 answers
What is primary key
SQL
7 votes241 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote243 views1 answer
Top frequency in sql server
SQL
0 vote247 views1 answer
Raiserror with nowait
SQL
0 vote247 views1 answer
Resullt all update knex mysql
SQL
7 votes217 views1 answer
Query delete duplicates
SQL
1 vote235 views1 answer
Order by oracle
SQL
0 vote258 views1 answer
Mariadb set vertical output format
SQL
4 votes240 views1 answer
Oracle select first 10 rows
SQL
0 vote262 views1 answer
Cube oracle
SQL