ToDo #560 » 20240521_終了日手動変更対応SQL.txt
| 1 |
select * from itemshop |
|---|---|
| 2 |
where item_cd = '012326' and shop_cd not in ('00210','00225','00230','00268','00426','00432','00701')
|
| 3 |
order by shop_cd |
| 4 |
|
| 5 |
update itemshop |
| 6 |
set endday = '99991231', |
| 7 |
end_date = '9999-12-31', |
| 8 |
update_by = 'System admin', |
| 9 |
update_at = '2024-05-21 12:20:00+00' |
| 10 |
where item_cd = '012326' and shop_cd not in ('00210','00225','00230','00268','00426','00432','00701')
|
| 11 |
|
| 12 |
update itemshop |
| 13 |
set endday = '99991231', |
| 14 |
end_date = '9999-12-31', |
| 15 |
update_by = 'System admin', |
| 16 |
update_at = '2024-05-21 12:20:00+00' |
| 17 |
where item_cd = '148661' and shop_cd not in ('00210','00225','00230','00268','00426','00432','00701')
|
| 18 |
|
| 19 |
update itemshop |
| 20 |
set endday = '99991231', |
| 21 |
end_date = '9999-12-31', |
| 22 |
update_by = 'System admin', |
| 23 |
update_at = '2024-05-21 12:20:00+00' |
| 24 |
where item_cd = '122161' and shop_cd not in ('00210','00225','00230','00268','00426','00432','00701')
|