mysql counts how many records are generated in a day
- coldplay.xixiOriginal
- 2020-09-29 14:51:462790browse
Mysql method to count how many records are generated in a day: Use sql statement to implement, the code is [SELECT date(reserve_begin_time), count(1) from brother_reserve group by date(...)].
Mysql method of counting how many records are generated in a day:
SELECT date(reserve_begin_time),count(1) from brother_reserve group by date(reserve_begin_time) ORDER BY reserve_begin_time desc
The statistical results are as follows:
More related free learning recommendations: mysql tutorial(Video)
The above is the detailed content of mysql counts how many records are generated in a day. For more information, please follow other related articles on the PHP Chinese website!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn