MYSQL如何连接字符，并 exec sp_executesql 拼接的字符串

Question

set sql = " 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')+")";exec sp_executesql  sql 我知道MySQL没 + 连字符想问一下 如何替换。。

Answer 1

create procedure sp_test()
begin
  set @sql=concat('xxxx','xxx');
  prepare stmt from @sql;
  execute stmt;
end

Answer 2

MYSQL中用CONCAT函数来进行字符串连接处理。