スレッド: 出版データ（m_syuppan) の旧システムから新システムへのデータ移行

[掲示板: SSSサイトに関する掲示板 -- 最新メッセージID: 1767 // 時刻: 2024/9/29(06:10)]

------------------------------

出版データ（m_syuppan) の旧システムから新システムへのデータ移行

前回の修正分でもれていたものを、
ふーんさんからのデータにもとづき更新しました。

-----------------------------------------------------
update m_syuppan
set nm_yle = 0.301,
nm_yls = 0.301,
nm_yl_a = 0.301
where dt_isbn in (
'0618285741')
1行処理されました。(32 msec.)
------------------------------------------------------------------------------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 0.401,
nm_yls = 0.401,
nm_yl_a = 0.401
where dt_isbn in (
'0199197555','0199197547','0199197512','0199197563','0689843909','0199197520','0199197539')
7行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
nm_yl_a = 0.501
where dt_isbn in (
'0199197652','0198451911','0198452012','0199197679','0199197660','0199197636','0199197628','0199197644')
9行処理されました。(63 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 0.801,
nm_yls = 0.801,
nm_yl_a = 0.801
where dt_isbn in (
'068984770X')
1行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 1.201,
nm_yls = 1.201,
nm_yl_a = 1.201
where dt_isbn in (
'0194335704','1564025969')
2行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
nm_yl_a = 1.501
where dt_isbn in (
'4770020759')
1行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 2.001,
nm_yls = 2.001,
nm_yl_a = 2.001
where dt_isbn in (
'159116172X')
1行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 2.401,
nm_yls = 2.401,
nm_yl_a = 2.401
where dt_isbn in (
'0590474839','0140379835')
2行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 3.001,
nm_yls = 3.001,
nm_yl_a = 3.001
where dt_isbn in (
'058250380','0531165604','L569310963')
1行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 3.801,
nm_yls = 3.801,
nm_yl_a = 3.801
where dt_isbn in (
'1880158302','0385335881')
2行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 4.001,
nm_yls = 4.001,
nm_yl_a = 4.001
where dt_isbn in (
'0141301112','0141301074','0140375333','0688038832')
4行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 4.501,
nm_yls = 4.501,
nm_yl_a = 4.501
where dt_isbn in (
'140549706')
0行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 6.501,
nm_yls = 6.501,
nm_yl_a = 6.501
where dt_isbn in (
'0440414806')
1行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 9.001,
nm_yls = 9.001,
nm_yl_a = 9.001
where dt_isbn in (
'0007119313')
1行処理されました。(32 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
nm_yl_a = 0.501
where dt_isbn in (
'0199164428','4872431529','4534035721','0590443852','059044087','0582344034','0439178746','0140502963','0679832270','0394809378','059044185X','0439113210','0140380299','0582428661','0060235152','0590866362','0439099099','014037387x','0201193647','0142301337','0141303670','0439099781','0439040213','0916291081','0140370013','076360013X','0064431886','0590602489','0763617156','0448405113','0448419777','0448425459','0141300841','059054344x','0199172315','0394806220','0448414929','0064430227','0448409356','0064430243','0395479460','0394870239','0590420445','0064430235','4887358199')
42行処理されました。(172 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
nm_yl_a = 1.501
where dt_isbn in (
'019916066X','0141305827','0582456215','058242318X','4834016463','0140386920','0439113202','0375806261','0679867384','0582448123','0590440624','043527161X','0439095514','0099296713','0064434729','0099697203','0435271601','0688098312','0804833486','0804833478','0804833494','0064430200','0613005058','0582463955','0140816135','0140365443','0749643110','0744507960','0689818858','0590463381','0064440338','0590372165','0582428696','0439087538','1550747797','0195818962','039480001X','0439358043','0194224198','4265800475','0199168636','0199185697','019194831','0199168717')
43行処理されました。(265 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 2.501,
nm_yls = 2.501,
nm_yl_a = 2.501
where dt_isbn in (
'0721706460','0721706479','0582468922','0521559286','9620014286','0582468876','0670833789','074455439X','0517556480','0064431789','0516273078','0516202197','0099917203','0698115546','0694009555','0060256656','4051043193','0721441106','0590681583','0140503005','0140540563','0448419955','0195818970','0582465753','0007158459','0552528188','0516270214','0516270591','0516267582','0516269941','0516264354','0688109950','0516263765','051626270X','0516234870','0516235761','037002020','0590474847','0590602896','0590603221','059060323X','0590673246','0194219364','4770022042','0439114292','0590421298','0199194912','0582343607','0582454336')
48行処理されました。(375 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 3.501,
nm_yls = 3.501,
nm_yl_a = 3.501
where dt_isbn in (
'4896843088','0003750655','052143680X','052162598X','058241537X','0472086391','0521634784','0140816143','0824820983','0152020349','0374466238','0689811624','4770029136','4770029144','0439102758','0844204579','406186114X','4770029152','4770029128','0140321187','0531071804','0531139670','0749635428','0531164098','0749634545','053116411X','0749635509','0749635398','0749634456','4770029608','0749632089','0531166376','0531139689','0531166384','0689844972','0531165078','0531165612','0531164527','0749630957','0531155641','0531166406','0307265145','030726517X','0307265102','0679890793','0671535528','0671568647','0671008153','1587170434','0671008161','0380012863','0671535536','0671527118','0375800662','9620014804','0140383905','0435271989','0435273167','0552546453','0590442449','014131303X','0140314466','0486274004','0781432715','0689842937','0582343585','0582454379','0809206730')
68行処理されました。(515 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 4.501,
nm_yls = 4.501,
nm_yl_a = 4.501
where dt_isbn in (
'0721706533','0521577683','0582451671','0689843593','0395520177','0590457268','0590477625','0689842694','006440384X','4140350636','0141310022','0141303344','0380709570','0440419476','0064400565','0380709244','006440031X','044048474X','0064407667','4140350326','4140350393','4140350490','4140350431','0752837508','0340796146','1841215309','0340796189','0340796170','0340796197','0060270039','0064406520','0747560293','0064400042','0064406512','0064400050','0064400034','0064400085','0582343623')
38行処理されました。(172 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 5.501,
nm_yls = 5.501,
nm_yl_a = 5.501
where dt_isbn in (
'0439296579','0140364048','037446208','1557044236','0340738448','770022506','0316136794','0156465116','0237523299','4061860046','4061860216','009942732X','0141301120','1841210056','0440415705','0141301147','0786881852','0140344489','0394864034','0099290316','0679811761','0380728044','0330485024','0689836023')
22行処理されました。(125 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 6.501,
nm_yls = 6.501,
nm_yl_a = 6.501
where dt_isbn in (
'0194228169','019422693X','0194228134','0194226921','058245140X','0194226948','0516234889','0689818823','0440445450','0152024859','4061860232','0786811560','4061860194','4061860445','0446602744','0140374558','0671028006','0671028014','0671028030','0671028022','0689826990','4770022492','0141301058','0064403688','0689851987','0440236991','0140366717','0099854708','0440412676','0007152590','0006531334')
31行処理されました。(125 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 7.501,
nm_yls = 7.501,
nm_yl_a = 7.501
where dt_isbn in (
'1569315442','0582275237','0375762051','0140387064','0152025219','4061860593','0152024689','0698118626','0006716679','0007115547','0007115601','0006716687','0140055770','1569470650','0446607207','0349110859','0446354678','0446602213','0671007718','0515121207')
20行処理されました。(110 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 8.501,
nm_yls = 8.501,
nm_yl_a = 8.501
where dt_isbn in (
'0721706541','0533294385','0312141440','0140308938','0848803248','0848803248','0140374566','0743444515','0425132951','0060934417','0060934417','0140386335','0061044407','0446674680','0679781587')
13行処理されました。(78 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 9.001,
nm_yls = 9.001,
nm_yl_a = 9.001
where dt_isbn in (
'0006471269','0345339681','0753810263','0747550999')
4行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle = 9.999,
nm_yls = 9.999,
nm_yl_a = 9.999
where dt_isbn in (
'4004300185','1569313695','1569314381','0345339711','0345339703')
5行処理されました。(47 msec.)
--------------------------------------------------------------------------------

------------------------------

---------------------------------
update m_review
set nm_yl = 0.301
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a = 0.301
and nm_yle is not null )
5行処理されました。(94 msec.)

ERROR: parser: parse error at or near "5" at character 150

--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.301
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a = 0.301
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.401
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a = 0.401
and nm_yle is not null )

0行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.401
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle= 0.401
and nm_yle is not null )

ERROR: parser: parse error at or near "betwen" at character 117

--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.401
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 0.400 and 0.401 )

1行処理されました。(63 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.501
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 0.500 and 0.501 )

20行処理されました。(390 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.801
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 0.800 and 0.801 )

0行処理されました。(62 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.201
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 1.200 and 1.201 )

0行処理されました。(94 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.501
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 1.500 and 1.501 )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.001
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 2.000 and 2.001 )

0行処理されました。(79 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.401
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 2.400 and 2.401 )

0行処理されました。(109 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.6
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 2.6 and 2.601 )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.6
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle = 2.6 )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.401
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle = 2.401 )

0行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.401
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 2.400 and 2.401 )

0行処理されました。(109 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.7
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 0.7 and 0.7 )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.7
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 0.7 and 0.701 )

9行処理されました。(62 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.8
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 0.899 and 0.901 )

92行処理されました。(141 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.4
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 1.399 and 1.401 )

43行処理されました。(93 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.501
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 1.499 and 1.501 )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.501
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 1.499 and 1.502 )

28行処理されました。(297 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.801
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 1.799 and 1.502 )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.801
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 1.799 and 1.802 )

50行処理されました。(110 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.901
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 1.899 and 1.902 )

1行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.401
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 2.4 and 2.402 )

3行処理されました。(110 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.501
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 2.5 and 2.502 )

33行処理されました。(282 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.601
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 2.6 and 2.502 )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.601
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 2.6 and 2.602 )

294行処理されました。(218 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.801
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 2.799 and 2.801 )

117行処理されました。(156 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 3.601
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 3.599 and 3.601 )

202行処理されました。(219 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 3.801
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 3.799 and 3.801 )

130行処理されました。(172 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 5.501
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 5.5 and 5.502 )

28行処理されました。(94 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 6.501
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 6.5 and 6.502 )

49行処理されました。(110 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 7.501
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 7.5 and 7.502 )

13行処理されました。(78 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 8.501
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 8.5 and 8.502 )

6行処理されました。(62 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 3.501
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 3.5 and 3.502 )

15行処理されました。(109 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 3.801
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 3.8 and 3.802 )

2行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 4.001
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 4.0 and 4.002 )

27行処理されました。(79 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 4.501
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 4.5 and 4.502 )

85行処理されました。(109 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 9.001
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 9.0 and 9.002 )

8行処理されました。(46 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 9.999
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yle between 9.99 and 10 )

4行処理されました。(47 msec.)
--------------------------------------------------------------------------------