/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

9 votes359 views3 answers
Postgres make sql dump
SQL
0 vote325 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
6 votes352 views2 answers
Insert into select mysql
SQL
0 vote325 views1 answer
Find wordpress version in database
SQL
0 vote346 views1 answer
Template MySQL Zabbix agent
SQL
0 vote384 views1 answer
Install mysql on bash
SQL
0 vote391 views1 answer
Connect google bigquery connect using sqirrel
SQL
10 votes313 views3 answers
Sql limit results
SQL
0 vote299 views1 answer
Sql runnignsum
SQL
1 vote358 views1 answer
Oracle insert multiple rows into same table
SQL

Share