mysql count groupings

Question

CREATE TABLE `articles_entities` (
  `id` CHAR(36) NOT NULL,
....
  `created` DATETIME DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `created` (`created`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8;

I am trying to create a query that gives me the count of records by day.. e.g

Day 1: 23 
Day 2: 343 
etc...

Please note the output is not the exact format I want, just a display of what data I want.

Lizard · Accepted Answer · 2010-12-06 23:28:26Z

2

While writing the question I realised just how easy this is....

SELECT COUNT(*), DATE_FORMAT(created, '%Y%m%d') AS testgroup FROM articles_entities GROUP BY testgroup;

answered Dec 6, 2010 at 23:28

Lizard

45.3k39 gold badges108 silver badges170 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql count groupings

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related