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;
