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 vote274 views1 answer
How to add auto increment primary key
SQL
0 vote196 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote275 views1 answer
Postgressql uuid
SQL
0 vote268 views1 answer
Authentication modes in sql server
SQL
3 votes252 views1 answer
Sql select second max
SQL
-2 votes252 views1 answer
Trunc in sql
SQL
0 vote272 views1 answer
Sql get table last modified time
SQL
6 votes207 views1 answer
SQL insert all columns
SQL
0 vote185 views1 answer
Sql developer export connections
SQL
0 vote176 views1 answer
Get who is hired in month in sql
SQL