Update date one year in mysql

Question

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

User · Answer

For multiple interval types use a nested construction as in:

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

For updating a given date in the column date to 1 year + 1 day

User · Answer

This post helped me today  but I had to experiment to do what I needed  Here is what I found   Should you want to add more complex time periods  for example 1 year and 15 days  you can use  UPDATE tablename SET datefieldname   curdate     INTERVAL 15 DAY   INTERVAL 1 YEAR    I found that using DATE ADD doesn t allow for adding more than one interval  And there is no YEAR DAYS interval keyword  though there are others that combine time periods  If you are adding times  use now   rather than curdate

User · Answer

You could use DATE ADD    or ADDDATE with INTERVAL   UPDATE table SET date   DATE ADD date  INTERVAL 1 YEAR

[mysql] Update date + one year in mysql

Examples related to mysql

Examples related to date