MySql存储过程的问题 - MS-SQL Server / 疑难问题

-- --------------------------------------------------------------------------------
-- Routine DDL
-- --------------------------------------------------------------------------------
DELIMITER $$

CREATE DEFINER=`root`@`` PROCEDURE `new_routine`(
  _startMonth int,
  _Endmonth int)
BEGIN

DECLARE stmt VARCHAR(4000);
set @tablename='ClubActionLog'+@month;
SET stmt=CONCAT('Create Table ','@tablename','Select * from ClubActionLog Where LogMonth between _startMonth and _Endmonth');
set @selsql=stmt;
prepare s1 from @selsql;
execute s1;
DEALLOCATE PREPARE s1;

END$$

希望得到的结果是查询ClubActionLog表中LogMonth列在传进来的值之间的时候把创建一张新的表 并且把记录复制到一张新的表，新表的表名是原表表名加上本月月份
不过这个好象不能执行，希望各位高手帮我看看好吗

---

mysql的?不懂,帮顶.

---

引用

mysql的?不懂,帮顶.

.