MySQL基础：动态SQL语句

MySQL基础：动态SQL语句2014-06-23 iteye 85977328在存储过程中，动态拼接一个字符串,然后执行之.Sql代码

DROP PROCEDURE IF EXISTS demoSp; CREATE PROCEDURE demoSp（）BEGINset @sqlstr=concat（"select count（*） from ", "dual"）;prepare stmt from @sqlstr;EXECUTE stmt; deallocate prepare stmt;END;