MYSQL动态创建表名，表名由存储过程参数带入
我这样写存储过程不对，创建的不是我参数指定名称的表名。
CREATE PROCEDURE Create_table2(pro_name VARCHAR(50))
BEGIN
DROP TABLE if EXISTS pro_name;
CREATE TABLE pro_name (id2 INT not null AUTO_INCREMENT primary key)
(
SELECT a.run_id,c.run_name,c.flow_id,a.prcs_id , a.user_id,b.user_name,a.prcs_flag,c.end_time, a.DELIVER_TIME,d.del_flag FROM flow_run_prcs a left JOIN `user` b ON a.user_id=b.user_id left JOIN flow_run c ON a.run_id=c.run_id left JOIN flow_run d ON a.run_id=d.run_id
WHERE EXISTS(select 1 from flow_run_prcs f where f.run_id=a.run_id HAVING MAX(prcs_id)<>MIN(prcs_id) AND MIN(prcs_id)=1 ) and d.DEL_FLAG<>1
ORDER BY run_id ,prcs_id
);
END
MYSQL中动态语句需要使用PREPARE。
先利用字符串操作得到SQL语句，然后利用PREPARE进行执行。
