关于MYSQL的concat

declare sql varchar(2000);
set sql = concat(" insert into mo ","(id,smg_type,srcid,spnumber,srctermid,code,msgcontent,linkid,recvtime) VALUES(",cast(ifnull(new.id,-1) as varchar(20)),",",cast(ifnull(new.smg_type,-1)as varchar(20)),",",ifnull( new.srcid,'null'),",",ifnull(new.spnumber,'null'),",",ifnull(new.srctermid,'null'),",",",",ifnull(new.msgcontent,'null'),",",ifnull(new.linkid,'null'),",",ifnull(new.recvtime,'null'),")");


额一直报错，不知道这么拼接。。。求高人指点。求同行把。。公司要把MSSQL移到MYSQL里面。。。

这个要写在存储过程里

并且要set @sql=.....
需要+'@'
应为动态语句需要 prepare stmt from @sql;
  execute stmt;

错误信息是什么？