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

7 votes339 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote362 views7 answers
Les jointures sql server
SQL
0 vote380 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote351 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote382 views1 answer
Create a sql server database programmatically
SQL
0 vote353 views2 answers
Sql use not in
SQL
1 vote389 views1 answer
Tsql update datetime
SQL
1 vote358 views2 answers
Mysql: command not found
SQL
0 vote398 views1 answer
Oracle concat datetime
SQL
0 vote337 views0 answer
SQL