Foreign Key

How to Resolve ERROR 1712 (HY000): Index table_name is corrupted

November 20, 2015December 16, 2022

ERROR 1712 (HY000) Got this error when using mysqldump for backing up a database. At this moment, we can't do any operations but DDL. mysqldump:… Read More »

How to Resolve ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails

November 14, 2015December 15, 2022

ERROR 1217 (23000) Got a MySQL ERROR 1217 (23000) when tried to partition a table. mysql> alter table geolocations partition by ... ... ERROR 1217… Read More »

How to Resolve ERROR 1215 (HY000): Cannot add foreign key constraint

May 17, 2014December 11, 2022

ERROR 1215 (HY000) Saw a MySQL ERROR 1215 (HY000): Cannot add foreign key constraint when I was trying to add a foreign key constraint on… Read More »

How to Resolve ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails

March 18, 2014December 11, 2022

ERROR 1452 (23000) Met a MySQL ERROR 1452 (23000) when adding a foreign constraint on table orders: mysql> ALTER TABLE orders ADD CONSTRAINT orders_cid_fk FOREIGN… Read More »

How to Resolve ERROR 1025 (HY000): Error on rename of

September 30, 2013December 11, 2022

ERROR 1025 (HY000) An error ERROR 1025 (HY000) was thrown when I tried to rename a column in MySQL. mysql> alter table sales change column… Read More »