如何每24小时将mysql列重置为0? [英] How to reset mysql column to 0 each 24h?

问题描述

我有一个网站，允许用户下载PDF文件， 我每天为每个用户限制10个文件的下载，并将数字存储在MySQL数据库中.一切正常！

I have a website that let users download PDF files, I made a download limit 10 files per day for each user and I stored the numbers inside MySQL database. everything works great!

问题是:限制将被永久设置，我希望将其每24h重置为0. 是否有任何phpmyadmin命令或每隔24小时自动将该列重置为0或通过其他方式重置的内容！

The problem is: The limit will be set forever, I want it to reset to 0 each 24h. Is there any phpmyadmin command or something to reset that column each 24h to 0 automatically or any other way!

推荐答案

似乎您已经将下载计数存储在各种日志表中.

It looks like you are already storing the download counts in a log table of sorts.

为使这些计数过期，我建议使用MySQL固有的事件调度程序.您可能需要在服务器参数中启用它.

For expiring those counts, I suggest using the event scheduler native to MySQL. You may need to enable it in your server parameters.

语法看起来像这样:

CREATE EVENT myevent
    ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY
    DO
      UPDATE count_db.count_table SET count_column = 0;

这篇关于如何每24小时将mysql列重置为0?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！