Database record changing in time?

Hello!

I'm really curious how it works in webgames.

Let's say I'm having a row called "gold" in my MySQL database, and I want +1 gold every 10 minutes if "goldmines_number" is equal 1. When "goldmines_number" is 2 then I want +2 gold every 10 minutes etc.

How to write something like this?

Thanks a lot.

 

mySQL Events can be created to trigger events like you describe above.

Have a look here:

http://dev.mysql.com/tech-resources/articles/mysql-events.html#3