触发器mysqlif_mysql触发器if语句⽤法
BEGINDECLAREi_jcidVARCHAR(50);DECLAREi_jkcxVARCHAR(50);DECLAREi_jksjVARCHAR(50);DECLAREi_resultVARCHAR( -...
迪斯尼神奇英语全集BEGIN
DECLARE i_jcid VARCHAR(50);
payphone
DECLARE i_jkcx VARCHAR(50);wraps
DECLARE i_jksj VARCHAR(50);
DECLARE i_result VARCHAR(100) default '';
DECLARE i_did VARCHAR(50);
DECLARE i_locoID VARCHAR(50);
-- DECLARE i_hzkssj VARCHAR(50); -- 判断换装开始时间
layoff
michelle yeh
lect id,jkcx,jksj,dhzfa_id,locoID into i_jcid, i_jkcx, i_jksj,i_did,i_locoID from t_bbjk_hzjc t where t.locoID=(lect id from
新年贺词 英文
t_bbjk_locoinfo where locoNo=new.jcbh and locoTypeCode=new.jcxh and abj=new.AOrB)
上海惠灵顿国际学校学费and t.state<2 and (t.jkcx=new.ACX or t.jksj= new.ASJ) LIMIT 1;
if i_jcid!='' and i_jcid!=null then
抚顺翻译公司if i_jkcx='' or i_jkcx=null then t i_result = CONCAT(i_result,'00');
elif i_jkcx!='' and i_jkcx!=null and i_jkcx=new.ACX then t i_result = CONCAT(i_result,'11');
el
t i_result = CONCAT(i_result,'22');
end if;
if i_jksj='' or i_jksj=null then t i_result = CONCAT(i_result,'00');
elif i_jksj!='' and i_jksj!=null and i_jksj=new.ASJ then t i_result = CONCAT(i_result,'11');
vanceel
t i_result = CONCAT(i_result,'22');
end if;
t i_result = CONCAT(i_result,'000000000000000');
elif i_jcid='' or i_jcid=null then
t i_result='AAAAAAAAAAAAAAAAAAA';
el t @tmp=1;
end if;
update t_bbjk_hzjc t state='3',hzPersonGH=new.hzr,hzTime=new.jlsj,fhPersonGH=new.fhr,hzdd=new.hzdd,lyflag='0' where
id=i_jcid;-- i_jcid 为空不影响，有值执⾏更新
jota.................
END
if语句应该怎么写，哪位⼤神给指导⼀下，在线等，我上⾯这样写是有问题的，求指导展开
