Answers for "how to update foreign key when primary key changes mysql"

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 "how to update foreign key when primary key changes mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to update foreign key when primary key changes mysql"

Code answers related to "how to update foreign key when primary key changes mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to update foreign key when primary key changes mysql"

Code answers related to "how to update foreign key when primary key changes mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us