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 vote147 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
1 vote149 views1 answer
Show structure of table in sql
SQL
0 vote129 views1 answer
Zerar auto increment mysql
SQL
0 vote137 views1 answer
Sql get number of days between two dates
SQL
0 vote130 views1 answer
Sql sum if
SQL
4 votes135 views1 answer
To date oracle with time
SQL
5 votes140 views1 answer
Oracle nls session
SQL
5 votes132 views3 answers
Sql max value in column
SQL
7 votes135 views1 answer
Safe update mysql
SQL
0 vote163 views1 answer
Sqlite trim
SQL