MySQL Forums
Forum List  »  Newbie

Cannot delete a row and cannot find a table.
Posted by: Edmund Uba
Date: December 02, 2014 05:11AM

Need help, I cannot delete a row, and I cannot even drop the table. I do not have a table named #sql-848_730 so I cannot drop it. Can anyone help me?

ERROR 1451: 1451: Cannot delete or update a parent row: a foreign key constraint fails (`dqm_crm`.`#sql-848_730`, CONSTRAINT `#sql-848_730_ibfk_2` FOREIGN KEY (`qCode`) REFERENCES `survey_details_qCode` (`qCode`))
SQL Statement:
UPDATE `dqm_crm`.`survey_details_qCode` SET `qCode`='60181' WHERE `qCode`='60180'

Options: ReplyQuote


Subject
Written By
Posted
Cannot delete a row and cannot find a table.
December 02, 2014 05:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.