Thanks Patrick, Will this work on 3.23?
""Patrick Herber"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Do you mean something like that? > > UPDATE tablename SET date2=DATE_ADD(date1, INTERVAL -3 MONTH) > > Regards, > Patrick > >> -----Original Message----- >> From: Shaun [mailto:[EMAIL PROTECTED] >> Sent: Monday, 16 January 2006 15:27 >> To: mysql@lists.mysql.com >> Subject: UPDATE Date Column >> >> Hi, >> >> I have a 2 Date Columns in my table, how can I update the 2nd >> date column so that the dates are 3 months previous to the >> orignial date column for every row. >> >> Thanks for your advice >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
