Question · SQL and MySQL course · Module 9: Indexes and normalization
ON DELETE SET NULL
What will the ON DELETE SET NULL rule do when an author is deleted?
Answer options
- It will keep the books but set their autor_id column to NULL (no assigned author)
- It will delete all of that author's books
- It will delete the whole ksiazki table
- It will change the type of the autor_id column
You can check the correct answer by solving this task in the CodeWorlds game.