mySQL随记

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;