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

1 vote271 views1 answer
Can we drop a primary key
SQL
8 votes303 views5 answers
Grant permission in postgres
SQL
16 votes322 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote290 views1 answer
Sql server port 1434
SQL
51 votes519 views6 answers
Opera gx
SQL
1 vote283 views1 answer
Oracle create program if no exists
SQL
0 vote335 views1 answer
Sql query inline if
SQL
0 vote328 views1 answer
Dataframe lambda elif
SQL
12 votes294 views1 answer
Psql drop column
SQL
2 votes300 views1 answer
Sql to char function with date
SQL