现在想要这条语句24小时执行一次:
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;
标签
查看
651 次