1.向 comments 表中插入自增主键。
1.语法:
ALTER TABLE 表名
ADD 字段名
INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
alter table comments add ID int unsigned not null auto_increment primary key;
2.近一年类目数据查询。
select platform,industry,category,themonth,sales,uv,
cart_customers,collect_customers from sycm_category_market_month
where platform = "天猫" and industry in ("床上用品","流行男鞋",
"男装","尿片/洗护/喂哺/推车床","女鞋","女装/女士精品","饰品/流行首饰/时尚饰品新",
"手表","童鞋/婴儿鞋/亲子鞋","童装/婴儿装/亲子装","箱包皮具/热销女包/男包","运动鞋new",
"女士内衣/男士内衣/家居服")
and themonth BETWEEN "2017-03-01" AND "2019-02-01";
.3.按天行业类目数据查询。
select s.*,t.industry,t.category,t.cid from sycm_industrial_trend_sub s,
(select * from industry_cid
where industry_cid.industry in("流行男鞋",
"男装","女鞋","女装/女士精品","手表","箱包皮具/热销女包/男包"))t
where
s.thedate between "2019-03-03" and "2019-03-09"
or s.thedate between "2018-03-03" and "2018-03-09"
and s.cid = t.cid
order by s.thedate desc;