Update date + one year in mysql

Question

Hi,

When I want setting numerical value +1 in mysql table, I use e.g.:

UPDATE table SET number=number+1 WHEN ...

How can I set date + one year?

Thanks

Answer 1

You could use DATE_ADD : (or ADDDATE with INTERVAL)

UPDATE table SET date = DATE_ADD(date, INTERVAL 1 YEAR) 

Answer 2

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_adddate