Skip to content

Instantly share code, notes, and snippets.

@Gustavo-Kuze

Gustavo-Kuze/mysql_create_fk_error.md

Last active October 7, 2020 21:39
Show Gist options
  • Save Gustavo-Kuze/8e7d8654c2db59f82d7ba23387fe1fca to your computer and use it in GitHub Desktop.
Save Gustavo-Kuze/8e7d8654c2db59f82d7ba23387fe1fca to your computer and use it in GitHub Desktop.
Download ZIP
Erro ao criar chave estrangeira MySQL
Raw
mysql_create_fk_error.md

Mysql error 1452 - Cannot add or update a child row: a foreign key constraint fails

Para resolver esse problema, basta desabilitar a verificação de FKs antes de adicionar a nova referência, por exemplo:

SET foreign_key_checks = 0; // executar isso para desabilitar

/*Adicionar a foreign key aqui, ou cria manualmente no workbench*/

SET foreign_key_checks = 1; // executar isso para habilitar novamente
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment