使用事件创建表

iteye_17742

于 2009-09-14 09:30:46 发布

阅读量167

点赞数

分类专栏： Mysql 文章标签： SQL

Mysql 专栏收录该内容

15 篇文章

订阅专栏

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