I need this to be run every 24 hours:
delete tags from tags left join tagowners on tags.id=tagowners.tagId
where tagowners.tagId is null;
CREATE EVENT cleartags
ON SCHEDULE EVERY 24 HOUR
DO
delete tags from tags left join tagowners on tags.id=tagowners.tagId
where tagowners.tagId is null;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With