Deleting a primary key with a foreign key attached

programming
1

Hi.

I have a question.
If i do something like this

Delete from writers where id = ‘1’

I get errir #1451 - cannot delete or update a parent row: a foreign key constraint fails. (‘library’. ‘review’, CONSTRAINT ‘fk_review_book1’ FOREIGN KEY (‘bookID’) REFERENCES ‘book’ (‘ID’))

Now how would i go about do still get the same effect i want… Wich is removing the item with id 1 from my writers list, but also termination the connection with the other lists (preferably in 1 go)