mysql counts how many records are generated in a day

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!