Mysql
zhuwangyou1
我是个小菜鸟
展开
-
MySQL查询本周、上周、本月、上个月份数据的sql代码
查询当前这周的数据 SELECT name,submittime FROM enterprise WHERE YEARWEEK(date_format(submittime,'%Y-%m-%d')) = YEARWEEK(now()); 查询上周的数据 SELECT name,submittime FROM enterprise WHERE YEARWEEK(date_format(submitt...原创 2018-04-04 15:24:21 · 711 阅读 · 0 评论 -
mysql设置非主键字段自增
思路:首先把字段设置为key,然后更改为自增;例如:alter table asynch_task ADD KEY comp_index (code);alter table asynch_task modify code BIGINT(20) auto_increment;原创 2018-04-04 15:19:53 · 2781 阅读 · 0 评论