Get the App
SLTechnology News&Howtos  ›  Internet Technology  › 

How to query data for a certain period of time by mysql

Shulou Source: shulou.com Published: 2022-06-02 11:05:58 11月14日 Update

This article mainly shows you "how mysql queries data for a certain period of time", which is easy to understand and clear. I hope it can help you solve your doubts. Let me lead you to study and learn this article "how to query data for a certain period of time by mysql".

The sql statement is as follows:

SELECT * FROM log_data_clean WHERE DATEDIFF (occur_time,NOW ()) =-4; the above is all the contents of the article "how to query the data of a certain period of time by mysql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Tags: Data time time period query content article learning help easy to understand more organization knowledge editing industry sentence information information channel channel research Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Docker Microsoft Xiaomi macOS NVidia