bitscn.com
mysql触发器跳出当前循环方法
set @num=@unitlength/3;
label:
while i
     set @length=(select substring(@unit_sid_fk,1,@unitlength-3*i));
     set @sms_content=(select sms_content from sms_config where  sms_
type='smscall' and unit_sid_fk=@length);
     set @sms_counts=(select sms_counts from sms_config where sms_
type='smscall'and unit_sid_fk=@length);
     if @sms_content is not null then      
       insert into sms_task set mt_at_time=@date,mt_content=@sms_content,unit_
sid_fk=@unit_sid_fk,mt_
dst_num=@calltelephone,mt_add_time=@date,mt_group_id=@groupid,branch
_num=@sms_counts,mt_dst_size='1',sms_channel='smsport',mt_type_id='99';
       set new.sms_send='y';     
 leave label;
     end if;
set i=i+1;
end while;
   www.bitscn.com  
在while循环外面添加label: 用 leave label; 即可跳出当前循环。
bitscn.com