Answers for "mysql create foreign key on delete cascade"

SQL
1

update foreign key value in mysql

SET foreign_key_checks = 0;
UPDATE languages SET id='xyz' WHERE id='abc';
UPDATE categories_languages SET language_id='xyz' WHERE language_id='abc';
SET foreign_key_checks = 1;
Posted by: Guest on July-27-2020
0

mysql on delete

[CONSTRAINT [symbol]] FOREIGN KEY
    [index_name] (col_name, ...)
    REFERENCES tbl_name (col_name,...)
    [ON DELETE reference_option]
    [ON UPDATE reference_option]

reference_option:
    RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT
Posted by: Guest on November-30-2020

Code answers related to "mysql create foreign key on delete cascade"

Code answers related to "SQL"

Browse Popular Code Answers by Language