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 vote302 views1 answer
Python mysql show databases
SQL
1 vote310 views1 answer
Oracle create program if not exists
SQL
2 votes275 views1 answer
Sql missing records from another table
SQL
1 vote284 views1 answer
OstgreSQL version
SQL
0 vote276 views1 answer
Order by in codeigniter query builder
SQL
0 vote284 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
3 votes274 views3 answers
List columns in table postgres
SQL
0 vote306 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote277 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote260 views1 answer
Mysql auto increment default value with prefix month and year
SQL