All Questions
1 question
2
votes
3
answers
3k
views
How to optimize mysql group by with DATE_FORMAT
I have a sql.
select count(id) as total, DATE_FORMAT(create_time,"%Y-%m-%d") as create_date
from table_name
group by DATE_FORMAT(create_time,"%Y-%m-%d");
Then Definition of column ...
- 1,075