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 vote220 views1 answer
How to truncate a table in databse
SQL
0 vote229 views1 answer
Mysql error 1251
SQL
0 vote266 views2 answers
Mysql cast to varchar
SQL
1 vote241 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote218 views1 answer
Back up stored procedures mysql
SQL
0 vote290 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote191 views1 answer
Delete all rows from table sqlite
SQL
1 vote227 views1 answer
Sql eliminare un record
SQL
0 vote224 views1 answer
Mysql server not running
SQL
1 vote233 views1 answer
Set statiscis on in ssms
SQL