Cacher is the code snippet organizer for pro developers

EMPTY TABLE EVERY X TIME

CREATE EVENT `eventEmpty_calendar` ON SCHEDULE EVERY 7 DAY STARTS '2017-05-29 07:00:00' 
 ON COMPLETION NOT PRESERVE ENABLE DO TRUNCATE TABLE calendar
 
http://stackoverflow.com/questions/19555712/empty-a-mysql-table-hourly
http://stackoverflow.com/questions/15926826/truncate-multi-tables