MySQL存错过程动态执行sql的方式来返回结果集

DELIMITER $$ DROP procedure IF EXISTS pro_report_data $$  CREATE procedure pro_report_data(in startT  varchar(100),in stopT  varchar(100),in buyerFilter varchar(20),gfs varchar(2000),qfs varchar(2000))  BEGIN   declare colsStr varchar(2000);declare tableStr varchar(2000);declare whereStr varchar(2000);declare groupStr varchar(2000);declare sqls varchar(2000);call createReportSql4Other(null,null,0,buyerFilter,gfs,qfs,2,startT,stopT,0,colsStr,tableStr,whereStr,groupStr);set sqls= concat('select ',colsStr,' from ',tableStr,' where ',whereStr,' group by ',groupStr);set @ms=sqls; PREPARE s1 from @ms; EXECUTE s1; deallocate prepare s1; END$$DELIMITER; 

转载自：http://blog.csdn.net/liuxiao723846/article/details/47106359