Please check your syntax. It should look like this: UPDATE this_table SET this_date = $this_date, future_date = DATE_ADD($this_date,INTERVAL 90 DAY);
Don't forget your WHERE clause or else you populate every row. ----- Original Message ----- From: João Cândido de Souza Neto <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Wednesday, October 11, 2006 11:50:17 AM GMT-0500 US/Eastern Subject: Re: date_add function Why you don�t try this? UPDATE this_table SET this_date = $this_date, future_date = (DATE_ADD($this_date) INTERVAL 90 DAY) "Ed Curtis" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > > I'm having some trouble setting a future date within a table. I have one > column 'this_date' which is a DATE field and I'm trying to add 90 days to > it and set a column named 'future_date', also a DATE field. > > I don't know if the problem is that I'm trying to write the value into > the 'this_date' and 'future_date' fields in the same query. > > UPDATE this_table SET > this_date = $this_date, > future_date = (DATE_ADD(this_date) INTERVAL 90 DAY) > > > Would this work? > > Thanks, > > Ed > > -- 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]
