Question · SQL and MySQL course · Module 5: Modifying data (DML)
Dangerous UPDATE without WHERE
What will the command do: UPDATE ksiazki SET cena = 59.90; (without a WHERE clause)?
Answer options
- It will change the price of only the first book
- It will report an error and change nothing
- It will change the price of ALL books in the table to 59.90
- It will add a new book with a price of 59.90
You can check the correct answer by solving this task in the CodeWorlds game.