Is it possible to break the referential integrity when a foreign key constraint is set on an InnoDB table?Ans: NOP aminul On Thu, Nov 20, 2008 at 5:40 AM, Saidur Rahman <rana_0036@xxxxxxxxx> wrote: > Hello Experts > > Is it possible to break the referential integrity when a foreign key > constraint is set on an InnoDB table? > > Integrity constraint violation: 1452 Cannot add or update a child row: a > foreign > key constraint fails (`sumaria_magento/mg_catalog_category_product_index`, > CONSTRAINT `FK_CATALOG_CATEGORY_PRODUCT_INDEX_PRODUCT_ENTITY` FOREIGN KEY > (`product_id`) REFERENCES `mg_catalog_product_entity` (`entity_id) > > Reason.. > The Constraint dont find any Parent keys in parent table. But children for > these Product ids are present. That means... database have Children entries > without Parent ... > > Please visit http://ranawd.wordpress.com/ for more details........... > S.M. Saidur Rahman > Analyst Programmer > SureSoft Technology Limited Work: +8801911731214 > Mobile: +8801911731214 > rana_0036@xxxxxxxxx <rana_0036%40yahoo.com> > ranawd.wordpress.com > Visit MyBlogLog and get a signature like this! > > [Non-text portions of this message have been removed] > > > -- Md. Aminul Islam http://www.shopno-dinga.com Mob: 8801671670797 [Non-text portions of this message have been removed]
