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;
