MYSQL: Cannot delete or update a parent row: a foreign key constraint fails Turns out you can temporarily...

Please Visit: http://ift.tt/1ajReyV

MYSQL: Cannot delete or update a parent row: a foreign key constraint fails



Turns out you can temporarily disable foreign key checks:

SET FOREIGN_KEY_CHECKS=0;

Just be sure to restore them once you’re done messing around:

SET FOREIGN_KEY_CHECKS=1;http://ift.tt/1gwkFlh

http://ift.tt/1nB1sGL

MYSQL: Cannot delete or update a parent row: a foreign key constraint fails

from Public RSS-Feed of Jeffery yuan. Created with the PIXELMECHANICS 'GPlusRSS-Webtool' at http://gplusrss.com http://ift.tt/1gwkCG5

via LifeLong Community