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 vote303 views1 answer
Adding a default constraint to an existing column in sql
SQL
0 vote333 views3 answers
How to increase size of column in sql
SQL
3 votes462 views9 answers
Linq to sql converter online
SQL
1 vote330 views1 answer
Postgresql how to show table names
SQL
0 vote327 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
1 vote331 views1 answer
Hackerrank sql test solutions
SQL
-1 vote308 views3 answers
Create temp table in sql
SQL
5 votes305 views2 answers
Mysql drop table cascade
SQL
0 vote323 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote302 views1 answer
Postgressql uuid
SQL