关于MYSQL的concat

Question

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里面

Answer 1

这个要写在存储过程里并且要set  @sql=.....
需要+'@'
应为动态语句需要  prepare  stmt  from  @sql;
                execute stmt;