Question · SQL and MySQL course · Module 9: Indexes and normalization
ON DELETE CASCADE
What will the ON DELETE CASCADE rule do when an author is deleted?
Answer options
- It will set the books' autor_id to NULL
- It will automatically delete all books linked to that author
- It will block deleting the author forever
- It will copy the author to another table
You can check the correct answer by solving this task in the CodeWorlds game.