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 vote332 views1 answer
Mysql drop vs delete
SQL
1 vote341 views1 answer
Apex ORA-20999
SQL
0 vote327 views1 answer
Example of sql querry result sepapreted by comma
SQL
1 vote337 views1 answer
Sql in array query
SQL
12 votes304 views4 answers
SQL Where
SQL
-1 vote295 views2 answers
Sql query examples
SQL
1 vote321 views1 answer
Mysql get character set
SQL
1 vote395 views1 answer
OSError: mysql_config not found
SQL
0 vote362 views1 answer
Plsql check how much space all databases are consuming
SQL
1 vote320 views1 answer
How to get alternate records from a table in sql
SQL