Posted by Gerwazy on 06/22/06 22:38

One of field of my database is amount.
How can I update (set mark="X") as many rows as sum of the amount give
me <=20? (in Id order DESC)


|id| amount |
|1 | 8 | update this
|2 | 7 | this
|3 | 3 | and this
|4 | 11 | but not this (>20!)

• Next in forum: is it possible in MySQL?
• Prev in forum: coderwiki.com is starting and needs you!
• Thread view: is it possible in MySQL?

[Reply to this message]