subject:"Re\: \[PHP\] Way OT MySql Update"

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",