RE: DATE_ADD Dynamic Interval

2003-10-01 Thread Adam Carmichael
essage ----- From: "Adam Carmichael" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 30, 2003 9:45 PM Subject: DATE_ADD Dynamic Interval > Hi All, > > I am trying to create a table with a list of records where a script runs > about once every 10 minu

DATE_ADD Dynamic Interval

2003-09-30 Thread Adam Carmichael
Hi All, I am trying to create a table with a list of records where a script runs about once every 10 minutes that will update a certain field by an interval set (by an enum) in that particular record. My Script looks as follows: UPDATE foo_table SET NextDate=DATE_ADD(foo_table.NextDate,Period) W