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:
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.
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`))
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.