7
7
drop table if exists `�s�V`;
8
8
drop table if exists `�s�W`;
9
9
drop table if exists `�s�X`;
10
drop table if exists `�s�P�O`;
11
drop table if exists `�s�P�P`;
12
drop table if exists `�s�P�Q`;
14
11
SET character_set_database = sjis;
15
12
CREATE TABLE `�s�P` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = innodb;
18
15
CREATE TABLE `�s�S` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = myisam;
19
16
CREATE TABLE `�s�T` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = myisam;
20
17
CREATE TABLE `�s�U` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = myisam;
21
CREATE TABLE `�s�V` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = heap;
22
CREATE TABLE `�s�W` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = heap;
23
CREATE TABLE `�s�X` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = heap;
24
CREATE TABLE `�s�P�O` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = bdb;
25
CREATE TABLE `�s�P�P` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = bdb;
26
CREATE TABLE `�s�P�Q` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = bdb;
18
CREATE TABLE `�s�V` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = MEMORY;
19
CREATE TABLE `�s�W` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = MEMORY;
20
CREATE TABLE `�s�X` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = MEMORY;
27
21
INSERT INTO `�s�P` VALUES ('�����');
28
22
INSERT INTO `�s�Q` VALUES ('����������');
29
23
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\');
33
27
INSERT INTO `�s�V` VALUES ('�����');
34
28
INSERT INTO `�s�W` VALUES ('����������');
35
29
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\');
36
INSERT INTO `�s�P�O` VALUES ('�����');
37
INSERT INTO `�s�P�P` VALUES ('����������');
38
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\');
39
30
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P`;
40
31
REPLACE(`�b�P`,'�','��')
171
162
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�X`;
172
163
REPLACE(`�b�P`,'�\','�\�\')
174
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P�O`;
175
REPLACE(`�b�P`,'�','��')
177
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P�O`;
178
REPLACE(`�b�P`,'�','��')
180
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P�O`;
181
REPLACE(`�b�P`,'�','��')
183
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P�O`;
184
REPLACE(`�b�P`,'�','��')
186
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P�O`;
187
REPLACE(`�b�P`,'�','��')
189
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�P�P`;
190
REPLACE(`�b�P`,'��','����')
192
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�P�P`;
193
REPLACE(`�b�P`,'��','����')
195
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�P�P`;
196
REPLACE(`�b�P`,'��','����')
198
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�P�P`;
199
REPLACE(`�b�P`,'��','����')
201
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�P�P`;
202
REPLACE(`�b�P`,'��','����')
204
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�P�Q`;
205
REPLACE(`�b�P`,'�\','�\�\')
207
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�P�Q`;
208
REPLACE(`�b�P`,'�\','�\�\')
210
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�P�Q`;
211
REPLACE(`�b�P`,'�\','�\�\')
213
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�P�Q`;
214
REPLACE(`�b�P`,'�\','�\�\')
216
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�P�Q`;
217
REPLACE(`�b�P`,'�\','�\�\')
219
165
DROP TABLE `�s�P`;
220
166
DROP TABLE `�s�Q`;
221
167
DROP TABLE `�s�R`;