how in mysql regularly remove all repository specify the data in the table, instead of every library to write it again time task, beg god give directions!!!!!!

CodePudding user response:

The event + stored procedure,

CodePudding user response:

1, if need to periodically remove automatically, timing task is inevitable, Linux cron or mysql event;
2, either through cron + shell + SQL execution on a regular basis to the removal of the generated script, or through the event + procedure to perform dynamic SQL statements, see which block you more familiar with,