[掲示板: SSSサイト に関する掲示板 -- 最新メッセージID: 1767 // 時刻: 2024/11/11(04:22)]
上へ | 前のメッセージへ | 次のメッセージへ | ここから後の返答を全表示 | 返答を書き込む | 訂正する | 削除する
264. 書評のあらすじから データ登録者を復活させました。
お名前: 古川@SSS http://www.seg.co.jp/
投稿日: 2004/5/4(12:27)
------------------------------
下記の SQL でとりあえず、バナナさん、 Kianさん、Julie の登録を復活しました。
順次、他の方の分も復活させる予定です。
-----------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000036'
where dt_tuser ='K0000024'
and dt_arasuji ~ '.*(あきお).*'
167行処理されました。(109 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000067'
where dt_tuser ='K0000024'
and dt_arasuji ~ '.*(バナナ).*'
7行処理されました。(31 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000067'
where dt_tuser in ('K0000024','K00000001')
and dt_arasuji ~ '.*(バナナ).*'
0行処理されました。(16 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000067'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(バナナ).*'
10行処理されました。(46 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000011'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(Kian).*'
136行処理されました。(109 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000036'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(あきお).*'
44行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000009'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(Julie).*'
16行処理されました。(47 msec.)
上へ | 前のメッセージへ | 次のメッセージへ | ここから後の返答を全表示 | 返答を書き込む | 訂正する | 削除する
270. Re: 書評のあらすじから データ登録者を復活させました。
お名前: 古川@SSS http://www.seg.co.jp/
投稿日: 2004/5/5(00:16)
------------------------------
古川です。
下記の方々について、書評登録の初期登録者を修正しました。
1 admin
2 Ally
3 apple
4 ASUKA
5 DAWN
6 fumi
7 H.O.
8 hiro
9
10 KEN
11 Kian
12 kirino
13 Kyoko
14 K子
15 miki
16 minami
17 MOMA親爺
18 sakigoro
19 samats
20 sammy
21 shige
22 shin
23 SSS_admin
24 SSS
25 STINGRAY
26 sumisumi
27 tane
28 Terra
29 TOMO
30 tomoko
31 tribird
32 Tsukada
33 tutomuoh
34 yksi
35
36 あきお
37 あずき
38 アトム
39 イケリア ダマリア
40 えっちゃん
41 かのん
42 カワ
43 くいめい
44 ぐら
45 コアラ
46 こいけ
47 こねこ
48 こりんご
49 コンロイ
50 ジアス
51 しお
52 しゅろーだー
53 じゅん
54
55 すけさやパパ
56 すけさやママ
57 ターボー
58 たこ焼
59 ちーわ
60 ちかこ
61 ちせこ
62 ちびた
63
64 とんぼ
65 なっつ
66 ハーウェル
67
68 はにまる
69 はねにゃんこ
70 ひこ
71 ひまぞ
72 ぷーさん
73
74 ポロン
75 ぽんきち
76 まこと
77 まりあ
78 マリコ
79 ミヤビ
80 みゅう
81 ミルポワ
82 メイ
83 めぐぽん
84 メリーベル
85 メリザンド
86 モモ
87 やま
88 ヨクサル
89 レモン
90 ワタナベ
91 杏樹
92 円
93 遠子
94 管理人
95 間者猫
96 久子
97 酒井邦秀
98 秋男
99 職人
100 慎一郎
101 成雄
102 静流
103 豆太
104 抹茶アイス
105
106 涼音
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000036'
where dt_tuser ='K0000024'
and dt_arasuji ~ '.*(あきお).*'
167行処理されました。(109 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000067'
where dt_tuser ='K0000024'
and dt_arasuji ~ '.*(バナナ).*'
7行処理されました。(31 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000067'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(バナナ).*'
10行処理されました。(46 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000011'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(Kian).*'
136行処理されました。(109 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000036'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(あきお).*'
44行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000009'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(Julie).*'
16行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000045'
where dt_tuser in ('K0000024','K0000001')
and (dt_arasuji ~ '.*(りえ).*'
or dt_arasuji ~ '.*(rie).*'
or dt_arasuji ~ '.*(理恵).*' )
ERROR: parser: parse error at or near ")" at character 199
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000045'
where dt_tuser in ('K0000024','K0000001')
and ( dt_arasuji ~ '.*(りえ).*'
or dt_arasuji ~ '.*(rie).*'
or dt_arasuji ~ '.*(理恵).*'
)
ERROR: parser: parse error at or near ")" at character 213
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000045'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(りえ).*'
4行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000045'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(rie).*'
25行処理されました。(78 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000045'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(理恵).*'
8行処理されました。(63 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000045'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(コアラ).*'
1行処理されました。(31 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000045'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(こあら).*'
0行処理されました。(31 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000045'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(KOALA).*'
0行処理されました。(31 msec.)
--------------------------------------------------------------------------------
SELECT * FROM m_kojin
468件選択されました。(16 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000002'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(ALL).*'
2行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000003'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(apple).*'
0行処理されました。(31 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000004'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(DAWN).*'
0行処理されました。(31 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000007'
where dt_tuser in ('K0000024','K0000001')
and dt_arasuji ~ '.*(fumi).*'
2行処理されました。(32 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000006'
where dt_arasuji ~ '.*(fumi).*'
21行処理されました。(63 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000007'
where dt_arasuji ~ '.*(H.O).*'
and dt_tuser in ('K0000024','K0000001')
20行処理されました。(156 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000008'
where dt_arasuji ~ '.*(hiro).*'
and dt_tuser in ('K0000024','K0000001')
3行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000012'
where dt_arasuji ~ '.*(kirino).*'
and dt_tuser in ('K0000024','K0000001')
40行処理されました。(94 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000013'
where dt_arasuji ~ '.*(Kyoko).*'
and dt_tuser in ('K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000015'
where dt_arasuji ~ '.*(miki).*'
and dt_tuser in ('K0000024','K0000001')
4行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000016'
where dt_arasuji ~ '.*(minami).*'
and dt_tuser in ('K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000017'
where dt_arasuji ~ '.*(MOMA親爺).*'
and dt_tuser in ('K0000024','K0000001')
1行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000018'
where dt_arasuji ~ '.*(sakigoro).*'
and dt_tuser in ('K0000024','K0000001')
2行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000019'
where dt_arasuji ~ '.*(samats).*'
and dt_tuser in ('K0000024','K0000001')
17行処理されました。(62 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000020'
where dt_arasuji ~ '.*(sammy).*'
and dt_tuser in ('K0000024','K0000001')
2行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000021'
where dt_arasuji ~ '.*(shige).*'
and dt_tuser in ('K0000024','K0000001')
2行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000022'
where dt_arasuji ~ '.*(shin).*'
and dt_tuser in ('K0000024','K0000001')
30行処理されました。(78 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000025'
where dt_arasuji ~ '.*(STINGRAY).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
19行処理されました。(63 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000026'
where dt_arasuji ~ '.*(sumisumi).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
21行処理されました。(62 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000027'
where dt_arasuji ~ '.*(tane).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
10行処理されました。(62 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000028'
where dt_arasuji ~ '.*(Terra.*'
and dt_tuser in ('K0000023','K0000024','K0000001')
ERROR: Invalid regular expression: parentheses ( ) not balanced
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000028'
where dt_arasuji ~ '.*(Terra).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
4行処理されました。(63 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000029'
where dt_arasuji ~ '.*(TOMO).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(31 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000030'
where dt_arasuji ~ '.*(tomoko).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
5行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000031'
where dt_arasuji ~ '.*(tribird).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000032'
where dt_arasuji ~ '.*(Tsukada).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
8行処理されました。(62 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000033'
where dt_arasuji ~ '.*(tutomuoh).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
2行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000034'
where dt_arasuji ~ '.*(yksi).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
3行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000036'
where dt_arasuji ~ '.*(あきお).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(46 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000037'
where dt_arasuji ~ '.*(あずき).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
10行処理されました。(63 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000038'
where dt_arasuji ~ '.*(アトム).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
24行処理されました。(62 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000039'
where dt_arasuji ~ '.*(イケリア ダマリア).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000040'
where dt_arasuji ~ '.*(えっちゃん).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
13行処理されました。(63 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000041'
where dt_arasuji ~ '.*(かのん).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
6行処理されました。(46 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000042'
where dt_arasuji ~ '.*(カワ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
1行処理されました。(46 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000043'
where dt_arasuji ~ '.*(くいめい).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
37行処理されました。(63 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000044'
where dt_arasuji ~ '.*(ぐら).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
10行処理されました。(62 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000046'
where dt_arasuji ~ '.*(コイケ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000046'
where dt_arasuji ~ '.*(こいけ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000048'
where dt_arasuji ~ '.*(こりんご).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
9行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000047'
where dt_arasuji ~ '.*(こねこ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000049'
where dt_arasuji ~ '.*(コンロイ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000050'
where dt_arasuji ~ '.*(ジアス).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
10行処理されました。(63 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000051'
where dt_arasuji ~ '.*(しお).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
66行処理されました。(109 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000052'
where dt_arasuji ~ '.*(しゅりょーだー).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(46 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000053'
where dt_arasuji ~ '.*(しゅん).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(46 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000055'
where dt_arasuji ~ '.*(すけさやパパ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000056'
where dt_arasuji ~ '.*(すけさやママ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
1行処理されました。(31 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000057'
where dt_arasuji ~ '.*(ターボー).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
18行処理されました。(62 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000058'
where dt_arasuji ~ '.*(たこ焼き).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(32 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000059'
where dt_arasuji ~ '.*(ちーわ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000060'
where dt_arasuji ~ '.*(ちかこ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
14行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000061'
where dt_arasuji ~ '.*(ちせこ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
8行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000062'
where dt_arasuji ~ '.*(ちびた).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000064'
where dt_arasuji ~ '.*(とんぼ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
14行処理されました。(62 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000065'
where dt_arasuji ~ '.*(なっつ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
15行処理されました。(62 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000068'
where dt_arasuji ~ '.*(はにまる).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(31 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000069'
where dt_arasuji ~ '.*(はねにゃんこ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
1行処理されました。(31 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000070'
where dt_arasuji ~ '.*(ひこ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
25行処理されました。(78 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000071'
where dt_arasuji ~ '.*(ひまぞ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
4行処理されました。(63 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000072'
where dt_arasuji ~ '.*(ぷーさん).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
3行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000074'
where dt_arasuji ~ '.*(ポロン).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
12行処理されました。(63 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000075'
where dt_arasuji ~ '.*(ぽんきち).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
4行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000076'
where dt_arasuji ~ '.*(マコト).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000076'
where dt_arasuji ~ '.*(まこと).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
5行処理されました。(31 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000077'
where dt_arasuji ~ '.*(まりあ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
168行処理されました。(140 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000078'
where dt_arasuji ~ '.*(マリコ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
209行処理されました。(156 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000079'
where dt_arasuji ~ '.*(ミヤビ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
6行処理されました。(31 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000080'
where dt_arasuji ~ '.*(みゅう).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
11行処理されました。(46 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000081'
where dt_arasuji ~ '.*(ミルポワ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000082'
where dt_arasuji ~ '.*(メイ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
31行処理されました。(93 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000083'
where dt_arasuji ~ '.*(めぐぽん).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000084'
where dt_arasuji ~ '.*(メリーベル).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
1行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000085'
where dt_arasuji ~ '.*(メリザンド).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000086'
where dt_arasuji ~ '.*(モモ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
4行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000087'
where dt_arasuji ~ '.*(やま).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
1行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000088'
where dt_arasuji ~ '.*(ヨクサル).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
2行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000089'
where dt_arasuji ~ '.*(レモン).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
9行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000090'
where dt_arasuji ~ '.*(ワタナベ).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
55行処理されました。(78 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000091'
where dt_arasuji ~ '.*(杏樹).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
4行処理されました。(62 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000092'
where dt_arasuji ~ '.*(円).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
12行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000093'
where dt_arasuji ~ '.*(遠子).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
13行処理されました。(78 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000001'
where dt_arasuji ~ '.*(管理人).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000095'
where dt_arasuji ~ '.*(間者猫).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
2行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000096'
where dt_arasuji ~ '.*(久子).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
5行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000097'
where dt_arasuji ~ '.*(酒井).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
8行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000098'
where dt_arasuji ~ '.*(秋男).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000099'
where dt_arasuji ~ '.*(職人).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
34行処理されました。(63 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000100'
where dt_arasuji ~ '.*(慎一郎).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000101'
where dt_arasuji ~ '.*(成雄).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
10行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000102'
where dt_arasuji ~ '.*(静流).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(32 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000103'
where dt_arasuji ~ '.*(豆太).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000104'
where dt_arasuji ~ '.*(抹茶アイス).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
UPDATE m_syuppan
set dt_tuser ='K0000106'
where dt_arasuji ~ '.*(涼音).*'
and dt_tuser in ('K0000023','K0000024','K0000001')
4行処理されました。(47 msec.)
--------------------------------------------------------------------------------
上へ | 前のメッセージへ | 次のメッセージへ | ここから後の返答を全表示 | 返答を書き込む | 訂正する | 削除する
271. Re: 書評のあらすじから データ登録者を復活させました。 ← ありがとうございます。
お名前: 成雄
投稿日: 2004/5/5(00:40)
------------------------------
〉古川です。
〉下記の方々について、書評登録の初期登録者を修正しました。
〉101 成雄
確認しました。
ありがとうございました。