Shulou(Shulou.com)06/01 Report--

This article mainly introduces the method of mysql to limit the query time of sql, which can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Mysql limits sql query time: 1, query today, code is [select * from table name where to_days (time field name) = to_days (now ())]; 2, query yesterday, code is [SELECT * FROM table name WHERE].

Mysql's method of limiting sql query time:

Today

Select * from table name where to_days (time field name) = to_days (now ())

Yesterday

SELECT * FROM table name WHERE TO_DAYS (NOW ())-TO_DAYS (time field name)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.