1
drop table if exists `�s�P`;
2
drop table if exists `�s�Q`;
3
drop table if exists `�s�R`;
4
drop table if exists `�s�S`;
5
drop table if exists `�s�T`;
6
drop table if exists `�s�U`;
7
drop table if exists `�s�V`;
8
drop table if exists `�s�W`;
9
drop table if exists `�s�X`;
11
SET character_set_database = sjis;
12
CREATE TABLE `�s�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
13
CREATE TABLE `�s�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
14
CREATE TABLE `�s�R` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
15
CREATE TABLE `�s�S` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
16
CREATE TABLE `�s�T` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
17
CREATE TABLE `�s�U` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
18
CREATE TABLE `�s�V` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
19
CREATE TABLE `�s�W` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
20
CREATE TABLE `�s�X` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
21
INSERT INTO `�s�P` VALUES ('�����');
22
INSERT INTO `�s�Q` VALUES ('����������');
23
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\');
24
INSERT INTO `�s�S` VALUES ('�����');
25
INSERT INTO `�s�T` VALUES ('����������');
26
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\');
27
INSERT INTO `�s�V` VALUES ('�����');
28
INSERT INTO `�s�W` VALUES ('����������');
29
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\');
30
SELECT LOCATE('�',`�b�P`) from `�s�P`;
33
SELECT LOCATE('�',`�b�P`) from `�s�P`;
36
SELECT LOCATE('�',`�b�P`) from `�s�P`;
39
SELECT LOCATE('�',`�b�P`) from `�s�P`;
42
SELECT LOCATE('�',`�b�P`) from `�s�P`;
45
SELECT LOCATE('�',`�b�P`) from `�s�P`;
48
SELECT LOCATE('��',`�b�P`) from `�s�Q`;
51
SELECT LOCATE('��',`�b�P`) from `�s�Q`;
54
SELECT LOCATE('��',`�b�P`) from `�s�Q`;
57
SELECT LOCATE('��',`�b�P`) from `�s�Q`;
60
SELECT LOCATE('��',`�b�P`) from `�s�Q`;
63
SELECT LOCATE('��',`�b�P`) from `�s�Q`;
66
SELECT LOCATE('�\',`�b�P`) from `�s�R`;
69
SELECT LOCATE('�\',`�b�P`) from `�s�R`;
72
SELECT LOCATE('�\',`�b�P`) from `�s�R`;
75
SELECT LOCATE('�\',`�b�P`) from `�s�R`;
78
SELECT LOCATE('�\',`�b�P`) from `�s�R`;
81
SELECT LOCATE('�\',`�b�P`) from `�s�R`;
84
SELECT LOCATE('�',`�b�P`) from `�s�S`;
87
SELECT LOCATE('�',`�b�P`) from `�s�S`;
90
SELECT LOCATE('�',`�b�P`) from `�s�S`;
93
SELECT LOCATE('�',`�b�P`) from `�s�S`;
96
SELECT LOCATE('�',`�b�P`) from `�s�S`;
99
SELECT LOCATE('�',`�b�P`) from `�s�S`;
102
SELECT LOCATE('��',`�b�P`) from `�s�T`;
105
SELECT LOCATE('��',`�b�P`) from `�s�T`;
108
SELECT LOCATE('��',`�b�P`) from `�s�T`;
111
SELECT LOCATE('��',`�b�P`) from `�s�T`;
114
SELECT LOCATE('��',`�b�P`) from `�s�T`;
117
SELECT LOCATE('��',`�b�P`) from `�s�T`;
120
SELECT LOCATE('�\',`�b�P`) from `�s�U`;
123
SELECT LOCATE('�\',`�b�P`) from `�s�U`;
126
SELECT LOCATE('�\',`�b�P`) from `�s�U`;
129
SELECT LOCATE('�\',`�b�P`) from `�s�U`;
132
SELECT LOCATE('�\',`�b�P`) from `�s�U`;
135
SELECT LOCATE('�\',`�b�P`) from `�s�U`;
138
SELECT LOCATE('�',`�b�P`) from `�s�V`;
141
SELECT LOCATE('�',`�b�P`) from `�s�V`;
144
SELECT LOCATE('�',`�b�P`) from `�s�V`;
147
SELECT LOCATE('�',`�b�P`) from `�s�V`;
150
SELECT LOCATE('�',`�b�P`) from `�s�V`;
153
SELECT LOCATE('�',`�b�P`) from `�s�V`;
156
SELECT LOCATE('��',`�b�P`) from `�s�W`;
159
SELECT LOCATE('��',`�b�P`) from `�s�W`;
162
SELECT LOCATE('��',`�b�P`) from `�s�W`;
165
SELECT LOCATE('��',`�b�P`) from `�s�W`;
168
SELECT LOCATE('��',`�b�P`) from `�s�W`;
171
SELECT LOCATE('��',`�b�P`) from `�s�W`;
174
SELECT LOCATE('�\',`�b�P`) from `�s�X`;
177
SELECT LOCATE('�\',`�b�P`) from `�s�X`;
180
SELECT LOCATE('�\',`�b�P`) from `�s�X`;
183
SELECT LOCATE('�\',`�b�P`) from `�s�X`;
186
SELECT LOCATE('�\',`�b�P`) from `�s�X`;
189
SELECT LOCATE('�\',`�b�P`) from `�s�X`;