MySQL events with TRUNCATE and INSERT
You can create:


Step#1 - stored procedure, which will run as many queries as You need - http://dev.mysql.com/doc/refman/5.7/en/create-procedure.html
Step#2 - Native MySQL Events - which will call this stored procedure - https://dev.mysql.com/doc/refman/5.7/en/create-event.html


In case when You do not want use MySQL bud scheduler, You always can call this stored procedure from PHP, cron, any other SQL script and etc