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
使用事件创建表
最新推荐文章于 2021-01-27 19:45:14 发布