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.