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 votes99 views3 answers
How ot change name of column mysql
SQL
2 votes110 views1 answer
How to check if a row is null in sql
SQL
12 votes102 views2 answers
Delete all data in neo4j
SQL
0 vote113 views1 answer
Postgres 11 add primary key
SQL
0 vote117 views1 answer
Django mysqlclient connection string
SQL
18 votes115 views3 answers
Mysql add column default value
SQL
0 vote111 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote96 views1 answer
Alter table add foreign key mariadb example
SQL
1 vote113 views1 answer
Convert varchar to int in sqlite
SQL
0 vote105 views1 answer
Concatenate columns in table
SQL