#检测事件是否开启
show variables like “event_scheduler”; #开启事件(最好在我。初始化设置,因为重启后还会变回默认值)
set global event_scheduler =,,
#创建事件(从11月24号开始每天执行一次)
create EVENT eve_createTable
提醒SCHEDULE EVERY 1天
STARTS ,“2016 - 11 - 24,就是”,提醒COMPLETION PRESERVE 使
做
CALL pro_createTable (); 注:
<代码类=" sql关键字"> <代码类=" sql平原">
<代码类=" sql平原">
#创建存储过程(动态表名)
CREATE PROCEDURE pro_createTable ()
开始
DECLARE str VARCHAR (20000);
set str=, CONCAT (CREATE TABLE member_network_, DATE_FORMAT(现在(),' % Y % m % d '),”(
“id”,,长整型数字(20),NOT NULL AUTO_INCREMENT
“member_id”,,长整型数字(20),NULL DEFAULT NULL
“host_ip”,, varchar (50), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
“serv_crc”,, varchar (2000), CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL
“app_crc”,, varchar (200), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
“sync_time”,, timestamp NULL DEFAULT NULL
“online_time”,, datetime NULL DEFAULT NULL
“类型”,,varchar (500), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
“up_stream_flux”,, varchar (50), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
“down_stream_flux”,, varchar (50), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
“total_stream_flux”,, varchar (50), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
“line_no”,, varchar (50), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
“url”,, text CHARACTER SET utf8 COLLATE utf8_general_ci NULL
“行动”,,varchar (50), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
“sev_port”,, varchar (50), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
“sor_port”,, varchar (50), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
“协议”,,varchar (50), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
“regionCode”,, varchar (500), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 空,
“备忘录”,,varchar (500), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
“政策”,,varchar (100), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
“域名”,,varchar (100), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
“名字”,,varchar (255), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
“经办人身份证”,,varchar (255), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 空,
“client_name”,, varchar (255), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 空,
PRIMARY KEY (id),
INDEX “dept_type”, (“regionCode”(255),“serv_crc”(255),“online_time”,“名字”,,“类型”(255)),USING BTREE
)
引擎=InnoDB
DEFAULT CHARACTER 设置=utf8 整理=utf8_general_ci
AUTO_INCREMENT=1
ROW_FORMAT=紧凑
”);
SET @sqlstr=str;
得到@sqlstr获PREPARE stmt ;
EXECUTE 支撑;
deallocate prepare 支撑;
之前结束; 
mysql通过事件定时为数据库创建动态表名
