MySql 存储过程小例子

好久没写了，备案方便以后查询

BEGIN

declare customerId0 varchar(80);
declare type0 int;
declare count0 int;
declare done int;
declare date0 varchar(10);
declare cur cursor for 
(
	select de.customerId,de.`type`,count(1) as c,date_format(de.createTime,'%Y-%m-%d')
	from dowell_exception de 
	where de.`type` in(605,602)
	group by de.customerId,date_format(de.createTime,'%Y-%m-%d'),de.`type`
);



DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1;

OPEN cur;
    loop1: LOOP
        FETCH cur into customerId0, type0,count0,date0;

        IF done THEN
            LEAVE loop1;
        END IF;
        
        IF count0>=2 THEN
        
        		
        		 #select * from dowell_exception where customerId=customerId0 
		  		 #	and `type`=type0 and date_format(createTime,'%Y-%m-%d')=date0 order by createTime asc;
		  		 
		  		 delete from dowell_exception where id in(
		  		 	select id from(
		  		 			select id from dowell_exception where customerId=customerId0 
		  		 			and `type`=type0 and date_format(createTime,'%Y-%m-%d')=date0 order by createTime asc limit 1,10000
		  		 	) a
		  		 );
        END IF;
        
       
        #declare cur2 cursor for (select id); 

		  #select customerId;
        #SET number = number + 1;
    END LOOP;

END