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 vote183 views1 answer
Snowflake drop column
SQL
0 vote176 views1 answer
Mysql random number between 1 and 100
SQL
0 vote178 views1 answer
Sql update subtract value
SQL
1 vote175 views1 answer
Sql drop schema
SQL
0 vote166 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
12 votes167 views1 answer
Script to add new column in table sql
SQL
6 votes166 views3 answers
How to delete table sqlite
SQL
1 vote155 views1 answer
Sql delete row with auto increment
SQL
0 vote177 views2 answers
Sql 2 way of select unique
SQL
36 votes167 views6 answers
Delete from where sql
SQL