REVIEW DATA の YL＝０　となっているデータの復旧

---------------------------------
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行処理されました。(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行処理されました。(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 between 0.401 and 0.402
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 )

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_yle= 0.401
)

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_yle betwen 0.400 and 0.401 )

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 )

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.699 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 )

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.599 and 2.601 )

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.)
--------------------------------------------------------------------------------