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 vote186 views1 answer
List all permissions on a table in postgres
SQL
0 vote201 views1 answer
How much space does sql server take per row
SQL
0 vote180 views1 answer
Traccar mysql
SQL
0 vote169 views1 answer
Mysql Error Code: 1005
SQL
0 vote302 views1 answer
Provera dupliranih konatakata
SQL
0 vote223 views1 answer
Get initials name in sql
SQL
5 votes177 views2 answers
Sql server check port number
SQL
0 vote171 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote162 views1 answer
Postgresql create user roles
SQL
10 votes182 views3 answers
Sql check double value
SQL