动态SQL简单示例

SELECT * FROM A_test;

id	name
1	aa
2	aa2

  SELECT GROUP_CONCAT('', CONCAT(id,' as `',name,'`'))
  INTO @str
  FROM A_test WHERE id<=5;
  #结果为：1 as `aa`,2 as `aa2`
  	
  SET @str := CONCAT('select ',@str);

  PREPARE stmt FROM @str;         -- 预处理动态sql语句
  EXECUTE stmt ;                  -- 执行sql语句
  deallocate prepare stmt;        -- 释放prepare