PROMOTION CODE,PROMOTION NAME,START DATE,END DATE
SO,Special Offer,2016-04-01,2016-04-10
DP,Disk Promotion...,2016-05-05,2016-05-20
MS,Month Special,2016-06-01,2016-06-30
MP,Monitor Promotion,2016-07-10,2016-07...promotion_name varchar(50) comment '促销期名称',
start_date date comment '促销期开始日期',
end_date date...comment '促销期截止日期',
primary key (promotion_code)
);
-- 添加促销期数据
insert into promo_schedule values
(...use rds;
create table promo_schedule (
promotion_code varchar(10) comment 'promotion code',
promotion_name