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 vote385 views1 answer
Scheduled mysql database backup in linux
SQL
0 vote311 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote314 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
1 vote327 views1 answer
Spark sql convert string to date
SQL
0 vote300 views1 answer
Codigo crear tablas sql server
SQL
1 vote263 views1 answer
Ms sql how to see active job current run time
SQL
0 vote303 views3 answers
Sql count condition
SQL
9 votes328 views3 answers
Date format in sql
SQL
11 votes279 views1 answer
Reset identity sql server
SQL
0 vote285 views1 answer
Oracle last connection
SQL