Question

mysql 统计各个 uid 出现的次数

在第一个表里，每次用户登录就会增加一条信息：
id uid os
1 1 Android
2 2 Android
2 1 ios

需求是，统计这个表，得到以下结果并存入新表
id uid cishu
1 1 2
2 2 1

请问这个sql语句，怎么实现，
以后这个还要求用存储过程来写，谢谢。

Answer 1

select min(id) id,uid,count(uid) as cishu
from tablename
group by uid

Answer 2

select *,count(uid) as cishu group by uid

Answer 3

CREATE PROCEDURE tongji()
BEGIN
declare done tinyint default 0;
declare theuid,thecishu int;

declare cu cursor for SELECT uid,count(*) FROM tb1 GROUP BY uid;
declare continue handler for sqlstate '02000' set done=1;
open cu;
while done<1 do
fetch cu into theuid,thecishu;
if done<1 then
INSERT INTO tb2 (uid,cishu)VALUES(theuid,thecishu);
end if;
end while;
close cu;
SELECT * FROM tb2;

END