Automatic increment a field in mysql

Question

I' building up a browsergame. I was wondering what is the best way to build up the "money" system. i no need anything "fast". I mean, the cash cuold be updated every day \ week. Is that possible doing it automatically? Like at 00.00 of every sunday it update automatically? Of course i need to update it every time someone buy something so it shuold be auto incrementing but still modificable with php query system!

Thanks a lot!

Alex · Answer 1 · 2015-04-16T19:08:29.537

1

table wallets: id, user_id, amount

 UPDATE wallets SET amount = amount+10

So you can call this query every week and it will increment all wallets by 10.

http://sqlfiddle.com/#!9/99dfe/1

edited Apr 16 '15 at 19:08

answered Apr 16 '15 at 19:05

Alex

16,739
1
28
51

I' m looking for something that automatically call that query! I mean. there is a way that the amount is added automatically? – Alberto Candido Apr 16 '15 at 19:08
YUP! Great Alex, thanks a lot! May i ask u if u know a good guide about it? – Alberto Candido Apr 16 '15 at 19:12
http://stackoverflow.com/questions/21196613/run-a-mysql-query-as-a-cron-job – Alex Apr 16 '15 at 19:15

Automatic increment a field in mysql

1 Answers1