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 vote131 views3 answers
Average salary in sql
SQL
0 vote126 views1 answer
Postgresql certain first 4 characters in string
SQL
1 vote138 views1 answer
Oracle list data files
SQL
7 votes148 views1 answer
Query delete duplicates
SQL
1 vote132 views1 answer
Moodle query item quiz
SQL
22 votes146 views3 answers
SQL CHEATSHEET
SQL
2 votes138 views1 answer
Set column to not null mysql
SQL
0 vote149 views1 answer
T sql check active deadlock
SQL
2 votes140 views1 answer
Sql update \
SQL
1 vote134 views2 answers
Mysql show views
SQL