SQL Error Code: 1217

I ran into SQL Error Code: 1217. Cannot delete or update a parent row: a foreign key constraint fails.

To fix this, you have to find what’s referencing it:

SELECT
  TABLE_NAME,
  COLUMN_NAME,
  CONSTRAINT_NAME,
  REFERENCED_TABLE_NAME,
  REFERENCED_COLUMN_NAME
FROM
  INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
  REFERENCED_TABLE_NAME = 'exampleTableName';

Then delete those things first.