/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

5 votes192 views2 answers
Add days in oracle sql
SQL
3 votes141 views2 answers
Oracle sql truncate table
SQL
6 votes138 views1 answer
Wordpress change user password sql
SQL
2 votes157 views1 answer
How to show the whole table in sql
SQL
0 vote154 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote166 views2 answers
What is rownum in oracle
SQL
0 vote159 views1 answer
How to input data as id in database sql c#
SQL
3 votes140 views1 answer
Sql multiple column index
SQL
0 vote187 views1 answer
Sql to excel pgadmin
SQL
0 vote151 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL

Share