Update

:UPDATE Entity SET field:value WHERE condition

:UPDATE User SET status:"active" WHERE id = 1

:UPDATE User SET name:"John Updated", age:31, updated_at:"2024-01-15T10:30:00Z" WHERE id = 1

:UPDATE User SET verified:true WHERE email_confirmed = true AND created_at < "2024-01-01"

:UPDATE Product SET on_sale:true WHERE category = "Electronics"

:UPDATE User SET role:"premium" WHERE id IN (1, 2, 3, 4, 5)

:UPDATE User SET deleted_at:null WHERE id = 1

:UPDATE Product SET quantity = quantity + 10 WHERE id = 1
:UPDATE User SET login_count = login_count + 1 WHERE id = 1

:UPDATE Product SET stock = stock - 1 WHERE id = 1

:UPDATE User SET name = UPPER(name) WHERE id = 1

:UPDATE User SET deleted_at:"2024-01-15T10:30:00Z", active:false WHERE id = 1

:UPDATE User SET active:false WHERE last_login < "2023-01-01" AND active = true

:UPDATE Order SET 
  status:"shipped",
  shipped_at:"2024-01-15T10:30:00Z",
  tracking_number:"1Z999AA10123456784"
WHERE id = 1001

:UPDATE Product SET price = price * 1.1 WHERE category = "Electronics"

-- DANGEROUS: Updates ALL users
:UPDATE User SET status:"inactive"

-- SAFE: Updates specific user
:UPDATE User SET status:"inactive" WHERE id = 1