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", why would you need another column? SELECT dateorig, dateorig + INTERVAL 1 YEAR AS datenew, ... FROM ... ?? ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php