Please put the 2008-10-20 in single quotes
if you r are doing this in PHP
UPDATE this_table SET
this_date = $this_date,
future_date = DATE_ADD('$this_date',INTERVAL 90 DAY);
----- Original Message -----
From: Ed Curtis <[EMAIL PROTECTED]>
To: Rolando Edwards <[EMAIL PROTECTED]>
Cc: João Cândido de Souza Neto <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Sent: Wednesday, October 11, 2006 12:43:00 PM GMT-0500 US/Eastern
Subject: Re: date_add function
On Wed, 11 Oct 2006, Rolando Edwards wrote:
> 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.
Tried it, this is what I get back.
You have an error in your SQL syntax near 'future_date =
date_add(2008-10-20, INTERVAL 90 DAY) WHERE id ='
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
