mysql 触发器loop使用_mysql触发器跳出当前循环方法_MySQL

我不是女神ヾ 2022-10-31 12:09 189阅读 0赞

![9c98fe03383ffeca78ca12f3181f2137.png][]

...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\_si...

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

...length=(select SUBSTRING(@unit\_sid\_fk,1,@UnitLength-3\*i)); set @sms\_content=(select sms\_content from sms\_config where sms\_type='smsCall

...于Monxin 运行

//代码来源：Monxin ./config/functions.php

function sms($config,$language,$pdo,$sender,$phone\_number,$content)\{

//demo var\_dump(sms(se

...ode! // NB: You must have registered your ICQ\# at http://web.icq.com/sms/login/ in order for this script to work//\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

...unction send() \{

$email = new email(\[options....\]);

$sms = new sms(\[options....\]);

$email->send();

$sms

...于Monxin 运行

//代码来源：Monxin ./config/functions.php

function sms($config,$language,$pdo,$sender,$phone\_number,$content)\{

//demo var\_dump(sms(se

SMS Web Sender DemoSMS Web Sender DEMO!Any user...

...证码发送短信发送我们采用 overtrue/easy-sms 包，这是安正超开发的一个短信发送客户端，已经内置了很多短信平台，实现也很优秀。(吐槽：虽然有些细节有问题，例如不按照契约调用方法传递网关)首先...

... User: Administrator

\* Date: 2016/5/8 0008

\* Time: 下午 2:36

\*/

class Sms\{

//Luosimao api key

private $\_api\_key = '';

private $\_last\_e

...e mode!// NB: You must have registered your ICQ\# at http://web.icq.com/sms/login/ in order for this script to work//\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

[9c98fe03383ffeca78ca12f3181f2137.png]: /images/20221024/46a3c03dbc92440e8e2544d49759f353.png