MySQL autoincrement by day?

Question

How can I decrement a MySQL field every day?

Such as:

field1= 30 and after 24hours -> field1=29 until 0.

What do you actually need this for? I have a feeling you'd be much better off just calculating the value when you need it, without needing to decrement it in "realtime". — deceze, Aug 23 '12 at 15:05
What is the purpose of this functionality? Something tells me that your solution to a problem is more complicated than it needs to be. — Matt, Aug 23 '12 at 15:06

score 2 · Answer 1 · answered Aug 23 '12 at 15:07

2

You'd probably be better off placing the current date in the database, and then use DATEDIFF to get the days since. You could even do 30 - DATEDIFF and then have the number the way you want it.

answered Aug 23 '12 at 15:07

h2ooooooo

39,111
8
68
102

score 1 · Answer 2 · edited May 23 '17 at 12:09

1

You can execute a Unix cron job (there's some informations here) which will execute your PHP script every day.

edited May 23 '17 at 12:09

Community

1
1

answered Aug 23 '12 at 15:06

Julien Fouilhé

2,583
3
30
56

MySQL autoincrement by day?

2 Answers2