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`;
12
11
SET character_set_database = sjis;
13
12
CREATE TABLE `�s�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
16
15
CREATE TABLE `�s�S` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
17
16
CREATE TABLE `�s�T` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
18
17
CREATE TABLE `�s�U` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
19
CREATE TABLE `�s�V` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
20
CREATE TABLE `�s�W` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
21
CREATE TABLE `�s�X` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
22
CREATE TABLE `�s�P�O` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
23
CREATE TABLE `�s�P�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
24
CREATE TABLE `�s�P�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
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;
25
21
INSERT INTO `�s�P` VALUES ('�����');
26
22
INSERT INTO `�s�Q` VALUES ('����������');
27
23
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\');
31
27
INSERT INTO `�s�V` VALUES ('�����');
32
28
INSERT INTO `�s�W` VALUES ('����������');
33
29
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\');
34
INSERT INTO `�s�P�O` VALUES ('�����');
35
INSERT INTO `�s�P�P` VALUES ('����������');
36
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\');
37
30
SELECT LOCATE('�',`�b�P`) from `�s�P`;
196
189
SELECT LOCATE('�\',`�b�P`) from `�s�X`;
197
190
LOCATE('�\',`�b�P`)
199
SELECT LOCATE('�',`�b�P`) from `�s�P�O`;
202
SELECT LOCATE('�',`�b�P`) from `�s�P�O`;
205
SELECT LOCATE('�',`�b�P`) from `�s�P�O`;
208
SELECT LOCATE('�',`�b�P`) from `�s�P�O`;
211
SELECT LOCATE('�',`�b�P`) from `�s�P�O`;
214
SELECT LOCATE('�',`�b�P`) from `�s�P�O`;
217
SELECT LOCATE('��',`�b�P`) from `�s�P�P`;
220
SELECT LOCATE('��',`�b�P`) from `�s�P�P`;
223
SELECT LOCATE('��',`�b�P`) from `�s�P�P`;
226
SELECT LOCATE('��',`�b�P`) from `�s�P�P`;
229
SELECT LOCATE('��',`�b�P`) from `�s�P�P`;
232
SELECT LOCATE('��',`�b�P`) from `�s�P�P`;
235
SELECT LOCATE('�\',`�b�P`) from `�s�P�Q`;
238
SELECT LOCATE('�\',`�b�P`) from `�s�P�Q`;
241
SELECT LOCATE('�\',`�b�P`) from `�s�P�Q`;
244
SELECT LOCATE('�\',`�b�P`) from `�s�P�Q`;
247
SELECT LOCATE('�\',`�b�P`) from `�s�P�Q`;
250
SELECT LOCATE('�\',`�b�P`) from `�s�P�Q`;
253
192
DROP TABLE `�s�P`;
254
193
DROP TABLE `�s�Q`;
255
194
DROP TABLE `�s�R`;