search

Han-Gang / test

test
0 stars 0 forks source link

ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails #17

Open Han-Gang opened 5 years ago

Han-Gang commented 5 years ago

SET FOREIGN_KEY_CHECKS=0; -- to disable them SET FOREIGN_KEY_CHECKS=1; -- to re-enable them

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

Han-Gang commented 5 years ago

SHOW INDEX FROM xxx;