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

2 votes190 views1 answer
Sql to char function with date
SQL
2 votes236 views1 answer
Dbms transaction (psql)
SQL
3 votes209 views2 answers
Postgres alter table owner
SQL
0 vote206 views2 answers
Laravel: customize or extend notifications - database model
SQL
4 votes236 views3 answers
Mysql get column names from table
SQL
2 votes234 views2 answers
Mysql show table column comments sql
SQL
2 votes195 views1 answer
Oracle index size calculation
SQL
0 vote203 views1 answer
Connecting to my cloud sql server with c#
SQL
3 votes225 views1 answer
Oracle list privileges
SQL
0 vote193 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL