mysql 动态执行SQL文

在mysql存储过程当中动态执行sql文

mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> concat(@a,@b);
mysql> @a;
mysql> 参考：http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-prepared-statements.htmlPREPARE stmt1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';SET @a = 3;SET @b = 4;EXECUTE stmt1 USING @a, @b;SET @a = 'select * from table1 ';SET @b = 'where column1>10 limit 1';SET @a =PREPARE stmt1 FROMEXECUTE stmt1;