Question · SQL and MySQL course · Module 5: Modifying data (DML)
Combining conditions with AND
What does WHERE kraj = 'Egipt' AND rok_urodzenia > 0 mean in an UPDATE/DELETE command?
Answer options
- It acts on rows that satisfy at least one of the conditions
- It acts on all rows, because AND joins them
- It acts on rows that satisfy BOTH conditions at once
- It reports an error - WHERE can have only one condition
You can check the correct answer by solving this task in the CodeWorlds game.