mysql event

CREATE DEFINER=`root`@`localhost` EVENT `up_CreateDaily_LOG_event_ACHIEVE_LOG`

ON SCHEDULE

EVERY 24 HOUR STARTS '2013-10-11 01:30:00'

ON COMPLETION NOT PRESERVE

ENABLE

COMMENT ''

DO label1:

BEGIN

CALL up_CreateDaily_ACHIEVE_LOG();

END label1

CREATE DEFINER=`root`@`localhost` PROCEDURE `up_CreateDaily_ACHIEVE_LOG`()

LANGUAGE SQL

NOT DETERMINISTIC

CONTAINS SQL

SQL SECURITY DEFINER

COMMENT ''

BEGIN

DECLARE NSQLSTRING NVARCHAR (4000);

DECLARE NDATE VARCHAR (8);

SET NDATE = REPLACE(DATE_ADD(CURDATE(), INTERVAL 1 DAY) , '-', '');

SET @NSQLSTRING = CONCAT("

CREATE TABLE IF NOT EXISTS ACHIEVE_LOG_", NDATE , "

(      

       LogNo smallint DEFAULT NULL,

       EventDate timestamp ,

LogType int ,

ServerIdx smallint ,

ChannelIdx int ,

Seq bigint ,

CharNo bigint ,

AccountID varchar(31) ,

MakeCodeNo int ,

CharName varchar(31) ,

CharClass int ,

CharLevel int ,

WorldID int ,

WorldtemplateID int ,

AchieveID int ,

RewardType int ,

AchievePoint int ,

CharAchievePoint int ,

CallName varchar(100) ,

Class varchar(100) ,

KEY ACHIEVE_LogType_StartDate_IDX (LogType,EventDate),

KEY ACHIEVE_AccountID_IDX (AccountID)

);");

PREPARE stmt2 FROM @NSQLSTRING;

EXECUTE stmt2;

DEALLOCATE PREPARE stmt2;

END