RE: [PHP] Way OT MySql Update

2004-05-06 Thread Angelo Zanetti
VAL 1 MONTH); -> 1998-02-28 hope this helps Angelo -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 2:22 PM To: Dave Carrera; [EMAIL PROTECTED] Subject: Re: [PHP] Way OT MySql Update From: "Dave Carrera" <[EMAIL PROTECTED

Re: [PHP] Way OT MySql Update

2004-05-06 Thread John W. Holmes
From: "Dave Carrera" <[EMAIL PROTECTED]> > 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. UPDATE yourtable SET datenew = dateorig + INTERVAL 1 YEAR; Although... if "datenew" is always one year more than "dateorig",

[PHP] Way OT MySql Update

2004-05-06 Thread Dave Carrera
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