條件如下：
在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
uj5u.com熱心網友回復：
求各位大神略施援手啊uj5u.com熱心網友回復：
MySQL造結果集比較費力、但也是可以做到的
--insert into book_ing(a2,a3)
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
;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/82772.html
標籤：MySQL
上一篇：mysql 1064錯誤