MySQL update field until value is reached

Asked Jul 12 '19 at 22:42

Active Mar 01 '21 at 13:10

Viewed 78 times

I have an mysql table with file information with the following partially structure:

id  filename    size(mb)      status
1   one.pdf       100         active
2   two.pdf       200         active
3   three.pdf     50          active
4   four.pdf      120         active

Considering, for example, that I have a 300Mb limit, I want to update the status to inactive for the following rows after that value is reached. This would be the final result:

id  filename    size(mb)      status
1   one.pdf       100         active
2   two.pdf       200         active
3   three.pdf     50          inactive
4   four.pdf      120         inactive

Is there any way to do this with an mysql instruction to avoid performance issues by doing it programmatically?

Thanks

edited Mar 01 '21 at 13:10

Deepak Rai

2,163
3
21
36

asked Jul 12 '19 at 22:42

Mind Design

1

Take a look at this: https://stackoverflow.com/questions/2563918/create-a-cumulative-sum-column-in-mysql. It might point you in the right direction. – Mike Jul 12 '19 at 22:48
What if the limit was 290 or 310? – Strawberry Jul 13 '19 at 05:50
Yes it did! thank you! – Mind Design Sep 14 '20 at 18:33

MySQL update field until value is reached

0 Answers0