Hi List,

Sorry for this being way off topic but I need some help with a MySql sql
update.

I have a date column and have added a datenew column and want to do a table
wide update to make datenew 1 year more that date.

So:

Date = 2003-05-06
Datenew should be 2004-05-06

Each row should update the datenew for 1 year more that date col value.

Thank you for any help you may give and once again sorry for being ot.

Dave Carrera


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.677 / Virus Database: 439 - Release Date: 04/05/2004
 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to