mysql - thinkphp查询一个字段并查询该字段的每个值出现的次数
PHPz
PHPz 2017-04-10 17:40:38
0
4
288

感觉自己好笨啊。。。

PHPz
PHPz

学习是最好的投资!

membalas semua(4)
伊谢尔伦
M($table)->field('field,count(field)')->group('field')->select()
阿神

不要气馁
多熟悉下SQL就行了,和thinkPHP无关

select field,count(field) from table
迷茫

select field,count(field) as ct from (select field from field) as tb group by field order by field;不知对否,自行测试

左手右手慢动作

select field, count(field) from table group by field;
SQL GROUP BY

Muat turun terkini
Lagi>
kesan web
Kod sumber laman web
Bahan laman web
Templat hujung hadapan