Hi, I've got a question:
How would I be able to automatically truncate a mysql table at midnight every night? Is this not even possible, or really simple?
Thanks.
automatically truncate table daily
Moderator: General Moderators
Re: automatically truncate table daily
You can use an Event if your MySQL version support this. Check out the CREATE EVENT syntax. Or you can write a script to truncate it and set it as a cron.