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