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.