创建存储过程使用字符串并接sql再执行语句

DROP PROCEDURE if EXISTS getData;
CREATE PROCEDURE getData()
BEGIN
DECLARE str VARCHAR(50);
SET str = 'AX_1415';
set @sqlstr=concat('select 1234 ',str,' from jc_yg_82600 WHERE JCD_id=100000002 AND DataDate = ''20170713''');
-- 相当于select 123 AX_1415 from jc_yg_82600 WHERE JCD_id=100000002 AND DataDate = '20170713'    ' 转译字符
  PREPARE cmd from @sqlstr;
EXECUTE cmd;  
END