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

28 votes152 views4 answers
Mysql delete database
SQL
0 vote186 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote158 views1 answer
How to find symmetric pairs in sql
SQL
0 vote165 views1 answer
SQL Server date literal
SQL
-1 vote158 views4 answers
Restart mysql server ubuntu
SQL
2 votes141 views2 answers
Function in sql
SQL
0 vote159 views1 answer
Sql show founctions
SQL
1 vote143 views1 answer
Mysql select another database
SQL
7 votes174 views3 answers
Convert ansi sql
SQL
0 vote178 views1 answer
Sql basic commands
SQL