MySql´æ´¢¹ý³ÌµÄÎÊÌâ - Oracle / ¿ª·¢

-- --------------------------------------------------------------------------------
-- 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$$

Ï£ÍûµÃµ½µÄ½á¹ûÊDzéѯClubActionLog±íÖÐLogMonthÁÐÔÚ´«½øÀ´µÄÖµÖ®¼äµÄʱºò°Ñ´´½¨Ò»ÕÅÐÂµÄ±í ²¢ÇҰѼǼ¸´ÖƵ½Ò»ÕÅÐÂµÄ±í£¬Ð±íµÄ±íÃûÊÇÔ­±í±íÃû¼ÓÉϱ¾ÔÂÔ·Ý
²»¹ýÕâ¸öºÃÏó²»ÄÜÖ´ÐУ¬Ï£Íû¸÷λ¸ßÊÖ°ïÎÒ¿´¿´ºÃÂð

---

SET stmt=CONCAT('Create Table ',@tablename,'Select * from ClubActionLog Where LogMonth between _startMonth and _Endmonth')