[RESOLVED] Update all records in a database 364 days

[oh_maestro]

I have a calendar with events for this year in a SQL database that I would like to use for next year too (the events will remain the same). The days of the week are important; what is on Monday, November 6, 2006 should be on Monday, November 5, 2007.

I will copy the existing table to another table for the next year, so what I would want to do is update the dates to be 364 days from each date.

Does anyone know a command that I can update all records by 364 days?

The table is practice07
The field is PracticeDate (that holds the date that I want to update)

Thanks in advance!

[Piranha]

Looking at the Date functions, especially date_add, I think the following should work:

UPDATE table SET date = DATE_ADD(date, INTERVAL 364 DAY)

or

UPDATE table SET date = DATE_ADD(date, INTERVAL 52 WEEK)

[oh_maestro]

Thanks!
The 364 Day interval worked!
I tried the 52 Week interval first, and I received an error.

This saved me from totally redo-ing a 500 record database!