MySQL Count rows by date timestamp
From D3xt3r01.tkJump to navigationJump to search
I wanted to see a history of how many rows were inserted in a table by date. In that table I have a timestamp type column.
The `date` column is the one that has the timestamp type.
SELECT date(`date`), count(*) FROM `table` GROUP BY date(`date`);