/SQL/Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails

Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails

Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails

SET FOREIGN_KEY_CHECKS = 0; -- to disable FK checks (ex: for delete purpose)
SET FOREIGN_KEY_CHECKS = 1; -- to re-enable FK checks

1

Sqlstate[23000]: integrity constraint violation: 1451 cannot delete or update a parent row:

Schema::disableForeignKeyConstraints();
Schema::dropIfExists('tablename');
Schema::enableForeignKeyConstraints();

0

ERROR 1451: 1451: Cannot delete or update a parent row: a foreign key constraint fails

SET FOREIGN_KEY_CHECKS=0; -- to disable them
SET FOREIGN_KEY_CHECKS=1; -- to re-enable them

0

Source: stackoverflow.com

Similar codes

4 votes273 views1 answer
Rename stored procedure in sql server
SQL
0 vote279 views1 answer
Calculer pourcentage mysql
SQL
12 votes226 views2 answers
Delete all data in neo4j
SQL
4 votes231 views2 answers
Sql vs mysql
SQL
2 votes244 views3 answers
Oracle show column of table
SQL
3 votes238 views2 answers
Enter mysql command line
SQL
0 vote227 views3 answers
Get count of null in column sql
SQL
0 vote244 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote230 views1 answer
Add sqlite3 in lumen
SQL
3 votes253 views2 answers
To_char sql
SQL

Share