请教mysql中是否支持动态的sql语法

pbj968

请教mysql中是否支持动态的sql语法  如：
if xx= '1' then
  set a = "select * from  table1 " ;
else
set  a  = "select * from table2 " ;
end if ;

如有使用的朋友给我个例子，多谢

leix

DELIMITER $$

CREATE PROCEDURE test(xx int)
BEGIN
  if xx = 1 then
    set @a = 'select * from table1';
  else
    set @a = 'select * from table2';
  end if;

  PREPARE stmt FROM @a;
  EXECUTE stmt;
END $$

DELIMITER ;

qlks

上面的方法可以
但是我给个复杂的动态语句

PREPARE stmt FROM "SELECT ? FROM statements WHERE ? LIMIT ?, ?";
SET @a="a", @b="1", @c="0", @d="1";
EXECUTE stmt USING @a, @b, @c, @d;

pbj968

多谢二位的解答