且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Mysql 从单列中选择计数值

更新时间:2023-01-31 14:54:23

Use group by:

Use group by:

SELECT `key`, COUNT(*) FROM `test` GROUP BY `key`;