vonduck

Yes it looks like supposed, i guess, see below:

Hello, Im having problems using the mysql event function. The query im using is the following: CREATE EVENT newEvent ON SCHEDULE EVERY 1 DAY DO UPDATE orderrader SET vs=1 WHERE order_datum <= DATE_SUB(NOW(), INTERVAL 14 DAY) ; The event is supposed to update the vs-field to one 14 days after the row is written into the database. I checked the table out 15 days after the first row was inserted, but still no update. Thanks alot, Erik