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

1 vote284 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote398 views1 answer
Postgresql powershell query
SQL
0 vote295 views1 answer
ORA-13717
SQL
0 vote275 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
0 vote260 views2 answers
Sql query unique
SQL
0 vote259 views1 answer
Sql server is not
SQL
0 vote282 views1 answer
Psql attribute cannot login
SQL
1 vote272 views1 answer
Mysql show long running queries
SQL
1 vote270 views1 answer
Increase date by one day in sql oracle
SQL
0 vote294 views1 answer
Sql server information_schema temp tables
SQL