SQL Delete

[pritnep]

Not sure how to word this but...

1. Trying to Delete any rows from authorsLName of Hull.

DELETE FROM authors WHERE authorsLName = "Hull"

However get this error:

Cannot delete or update a parent row: a foreign key constraint fails (`books_database/titleauthors`, CONSTRAINT `titleauthors_ibfk_2` FOREIGN KEY (`taAuthorID`) REFERENCES `authors` (`authorID`))

I have a few other tables which it's drawing the foreign keys from but not sure how else to do it. Not sure if it will be any help but I've attached a file that contains the table and column names if that's any help.

2. I'm also having trouble with working out how to DELETE the rows with books published by publisher PO1 or PO4 from the table title_authors.

Thanks.

[akalyanram]

13.2.5.4. FOREIGN KEY Constraints of the MySQL 5.0 Reference manual might be of help.

regards
/k

[r937]

your foreign key says that you cannot delete an author who has books

[pritnep]

Got it working now, typo in the column name.

And got the other done.