Update date + one year in mysql

Viewed 134674

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

3 Answers
Related