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 vote185 views1 answer
Sql roll up rows into columns
SQL
19 votes192 views4 answers
Rename database in sql
SQL
14 votes197 views2 answers
Install mysqldump
SQL
2 votes245 views2 answers
Mysql write into table
SQL
2 votes194 views1 answer
Find all triggers in database
SQL
2 votes219 views1 answer
Oracle log files
SQL
0 vote209 views1 answer
Sql date time query find
SQL
1 vote219 views1 answer
Limit offset order by mysql
SQL
28 votes189 views4 answers
Delete database mysql
SQL
0 vote200 views1 answer
Create table with float datatype in sql server
SQL