Answers for "alter table table name add constraint foreign key references on delete restrict on update cascade"

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

Code answers related to "alter table table name add constraint foreign key references on delete restrict on update cascade"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "alter table table name add constraint foreign key references on delete restrict on update cascade"

Code answers related to "alter table table name add constraint foreign key references on delete restrict on update cascade"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "alter table table name add constraint foreign key references on delete restrict on update cascade"

Code answers related to "alter table table name add constraint foreign key references on delete restrict on update cascade"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us