mysql 存储过程 执行变量sql语句

set @sql = concat("select * from project where projectId in (", numProject, ")");

上面这个@sql 如何执行

我觉得是后台查 concat("select * from project where projectId in (", numProject, ")"); 传到前台
html set@这个值吧

用PREPARE 命令，不复杂的，你看看这篇博客：http://blog.csdn.net/xinyuan_java/article/details/50056741
另外也可参考：http://www.cnblogs.com/drcoding/p/4270241.html?tvd

set @sql = concat("select * from project where projectId in (", numProject, ")");

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;