使用事件创建表

begin
set @table_sql ='create table cdn';
#set @table_sql =  concat(@table_sql,DATE_FORMAT(NOW(), '%Y%m%d%H%i%s'));
set @table_sql = concat(@table_sql,curdate()+1);
set @table_sql = concat(@table_sql,'daycounts');
set @table_sql =  concat(@table_sql,"(
   id                   int not null auto_increment comment '自增长',
   domain               varbinary(500) not null comment '域名',
   years                int not null comment '年',
   months               int not null comment '月',
   days                 int not null comment '天',
   bandwidth            double not null comment '带宽',
   cdnip                varbinary(30) not null comment 'cdn ip',
   primary key (id)
)");
 PREPARE stmt1 FROM @table_sql;
 EXECUTE stmt1;
end