MySQL：删除忽略外键约束的行

so I am working on a few tables and there are some data inconsistency between them... One or two tables have a foreign key constraint on a particular table (call it table X), but that table has multiple rows with the foreign key column.so I am working on a few tables and there are s