Reset mysql Table automatically

Question

I have a database that stores some leads, it is possible to reset the tables of this database every day at a certain time or until it reaches so many lines?

Use phpmyadmin in Cpanel.

Answer 1

You can do with an event:

CREATE EVENT evento_diario
    ON SCHEDULE
        EVERY 1 DAY
        STARTS '2016-11-01 00:00:00' -- Data e hora para iniciar
    COMMENT 'Limpar tabela XPTO'
    DO
        TRUNCATE XPTO;

If you want to make based on X lines, just create a Trigger..