Way OT MySql Update
| From: | Dave Carrera | Date: | Thu, 06 May 2004 12:09:58 +0000 |
| Subject: | Way OT MySql Update | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-185515@lists.php.net to get a copy of this message | ||
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