0
I’m trying to create an event to delete lines, that column date is expired, or is less than the current date.
I was trying with the following command:
create event e on schedule every 1 day do delete from Reserve where date < curdate();
But then I was testing it by adding a line with an old date and changing the every 1 day for every 1 second But I didn’t succeed...
Could someone help me with the correct query for my problem?
5
CREATE EVENT IF NOT EXISTS `dbName`.`eventName`
ON SCHEDULE
EVERY 1 DAY // or 1 HOUR
COMMENT 'Description'
DO
BEGIN
DELETE FROM `dbName`.`TableName` WHERE `DateCol` < NOW();
END
Buddy adapt this code above! (as you did not provide the fields I can not adapt to your person :/ )
REMEMBERING IT IS NECESSARY TO ACTIVATE THE MySQL Event Scheduler
Source: https://stackoverflow.com/questions/18181458/auto-delete-a-record-in-table-when-date-is-expired
I didn’t know I had to activate something before :(. But it all worked out right here, Raphael. Thank you so much!
No problems, good luck on your project, any doubts I’m here to help, and if you want to grant the reward I’m happy :D, but still, good luck.
Yes, I will. But I can’t do it for another 23 hours. :))
Browser other questions tagged mysql
You are not signed in. Login or sign up in order to post.
Try Where trunc(date) < kurdate(). Or, see if the format of your field date is equal to the output of kurdate.
– Diego
If you try some other event or a different parameter for Where, it executes?
– Leonardo Coelho
I couldn’t, @Diego. And yes, the format used is the same.
– Naldson
@Leonardocoelho I tried with other parameters, but I did not succeed either...
– Naldson
it is good to use Cronjob for things like these.
– Raphael Caldas