drop procedure if EXISTS staff_stats;
delimiter //
create procedure staff_stats(IN v_project_id BIGINT)
BEGIN
declare v_eid int;
declare done INT DEFAULT true;
declare ret text DEFAULT('');-- 必须要设置为空,不然没法拼接
DECLARE v_segment INT;
DECLARE cur cursor for select eid from videotrack_eids WHERE project_id = v_project_id and staff_str_pid != "" and eid < 1000000;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = false;
OPEN cur;
WHILE done DO
fetch cur into v_eid;
select eid, segment_id from videotrack_tracklets WHERE project_id = v_project_id and eid = v_eid GROUP BY segment_id;
END WHILE;
CLOSE cur;
END //
delimiter;
call staff_stats(1591);
就这样