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

11 votes369 views2 answers
How to import mysql database command line
SQL
17 votes344 views2 answers
Mysql date to string
SQL
0 vote336 views1 answer
Restore backupfile discourse
SQL
5 votes341 views4 answers
Mysql on duplicate key update
SQL
0 vote337 views1 answer
Codigo crear tablas sql server
SQL
0 vote319 views1 answer
Mssql describe stored procedure sqlcmd
SQL
4 votes365 views5 answers
Get last query in codeigniter 4
SQL
0 vote372 views1 answer
Mysql change default collation
SQL
2 votes411 views1 answer
Tcl in sql
SQL
0 vote362 views1 answer
Postgresql extract hour and minutes from timestamp
SQL