这个可以放在触发器里面吗,如果触发器里面要实现 把count的结果存放到一个变量中,如何做。 declare @a varchar(20); select count(*) into @a from table; 是吗?
if new.spnumber = '1062836999' then insert into mo set id = new.id,smg_type=new.smg_type,srcid= new.srcid,spnumber= new.spnumber,srctermid = new.srctermid,code=' ',msgcontent =msgcontent1,linkid = new.linkid,recvtime = new.recvtime; end if; if new.spnumber = '10628369001' then end if; end不能这样写IF吗
select a into @a from table;mysql要放到存储过程里或者函数里,不能在客户端直接declare
declare @a varchar(20);
select count(*) into @a from table;
是吗?
insert into mo set id = new.id,smg_type=new.smg_type,srcid= new.srcid,spnumber= new.spnumber,srctermid = new.srctermid,code=' ',msgcontent =msgcontent1,linkid = new.linkid,recvtime = new.recvtime;
end if;
if new.spnumber = '10628369001' then
end if;
end不能这样写IF吗