Coding task · SQL and MySQL course · Module 5: Modifying data (DML)
Update by condition
WHERE can point to rows by a value other than id. Use a comparison operator.
Task
Write a command that in the ksiazki table sets dostepna to 0 for all books with cena greater than 100. Use a WHERE clause with the > operator.