10:55:43 DROP TABLE IF EXISTS people Error Code: 1451. Cannot delete or update a parent row: a foreign key constraint fails 0.000 sec code example
Example: 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