Desabilitando checagem de Foreign Key no MySQL
Dica rápida útil para restaurar um dump, por exemplo:
mysql> SET FOREIGN_KEY_CHECKS = 0;
mysql> SOURCE db_xyz.sql;
mysql> SET FOREIGN_KEY_CHECKS = 1;
Dica rápida útil para restaurar um dump, por exemplo:
mysql> SET FOREIGN_KEY_CHECKS = 0;
mysql> SOURCE db_xyz.sql;
mysql> SET FOREIGN_KEY_CHECKS = 1;
Tags: foreign key, mysql
This entry was posted on Monday, July 11th, 2011 at 14:32and is filed under MySQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.