Home  >  Article  >  Database  >  mysql counts how many records are generated in a day

mysql counts how many records are generated in a day

coldplay.xixi
coldplay.xixiOriginal
2020-09-29 14:51:462932browse

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 counts how many records are generated in a day

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:

mysql counts how many records are generated in a day

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