Command for incrementing datas?

Hi!

I want to increment a data in the mysql database periodicaly. How can I perform it?

My ideas:

UPDATE datatable SET Age=Age+1 where Name='MyName'

Code (markup):

or

UPDATE datatable SET Age=increment where Name='MyName'

Code (markup):

Is any of them correct?
If not please tell me a correct form?

Thanks

 

First one is the best if age is unknown to you and can easily be set on a loop to run through all applicable updates.

 

you can do that in mysql.