php读取数据库怎么分组,php – 如何在sql中按两列分组？

我有两个表,一个是“事件”,第二个是“门票”：

活动表：

============================

| event_id | event_name |

============================

| 101 | Running Event |

| 102 | Cycling Event |

============================

门票表：

==============================================================

| ticket_id | event_id | ticket_number | ticket_generate_date|

==============================================================

| 1 | 101 | 40001 | 2018-08-21 17:05 |

| 2 | 101 | 40002 | 2018-08-21 18:05 |

| 3 | 102 | 40001 | 2018-08-21 19:05 |

| 4 | 101 | 40003 | 2018-08-23 20:05 |

| 5 | 101 | 40004 | 2018-08-24 20:05 |

==============================================================

现在我想运行查询,以便我的输出如下所示：

================================================

| count ticket | event_name | day wise data |

================================================

| 2 | Running Event | 2018-08-21 |

| 1 | Cycling Event | 2018-08-21 |

| 1 | Running Event | 2018-08-23 |

| 1 | Running Event | 2018-08-24 |

================================================

我尝试了以下查询：

SELECT COUNT(ticket_id), ticket_generate_date FROM Tickets

WHERE ticket_generate_date >= DATE_FORMAT(curdate(), '%Y-%m-01')

GROUP BY DATE_FORMAT(ticket_generate_date, '%d-%b');

解决方法:

您只需要将第二个组选项添加到您已使用逗号的选项中.

我还使用了别名和INNER JOIN来获取事件名称.

SELECT

COUNT(t.ticket_id),

e.event_name,

DATE_FORMAT(t.ticket_generate_date, '%Y-%m-%d') as day_wise

FROM

Tickets t

INNER JOIN

Events e ON e.event_id = t.event_id

WHERE

t.ticket_generate_date >= DATE_FORMAT(curdate(), '%Y-%m-01')

GROUP BY

DATE_FORMAT(t.ticket_generate_date, '%Y-%m-%d'), e.event_name

标签：php,mysql,mysqli

来源： https://codeday.me/bug/20190622/1261978.html