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]
