条件如下:
在book_ing这个table中的A2栏位,写入2018年每一个周二对应的日期。每一个日期,在A3栏位分别写入数字1-8。格式如下
A2 A3
2018-07-31 1
2018-07-31 2
2018-07-31 3
.....
2018-08-07 1
2018-08-07 2
2018-08-07 3
在book_ing这个table中的A2栏位,写入2018年每一个周二对应的日期。每一个日期,在A3栏位分别写入数字1-8。格式如下
A2 A3
2018-07-31 1
2018-07-31 2
2018-07-31 3
.....
2018-08-07 1
2018-08-07 2
2018-08-07 3
SELECT dt.date, t.col
FROM (
select @row := @row + 1 as days, DATE_ADD(ymd, INTERVAL @row DAY) as date
from
(select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9 union select 10) t1,
(select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9 union select 10) t2,
(select 1 union select 2 union select 3 union select 4 ) t3,
(SELECT @row:=-1,DATE_FORMAT('2018-01-01', '%Y-%m-%d') ymd) r
)dt,
(select 1 col union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 ) t
where DAYOFWEEK(dt.date)=3 and days<365
order by date,col
;