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

13 votes142 views5 answers
Oracle list tables
SQL
7 votes126 views1 answer
Safe mode mysql
SQL
1 vote145 views1 answer
Right outer vs left outer join
SQL
0 vote130 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote147 views1 answer
Oracle right characters
SQL
0 vote142 views1 answer
Postgres read table structure
SQL
-1 vote145 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote186 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
-1 vote146 views1 answer
Mysql order by on condition
SQL
0 vote164 views1 answer
Create query in where clasue
SQL