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(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
16
15
CREATE TABLE `�s�S` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
17
16
CREATE TABLE `�s�T` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
18
17
CREATE TABLE `�s�U` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
19
CREATE TABLE `�s�V` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
20
CREATE TABLE `�s�W` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
21
CREATE TABLE `�s�X` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
22
CREATE TABLE `�s�P�O` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
23
CREATE TABLE `�s�P�P` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
24
CREATE TABLE `�s�P�Q` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
18
CREATE TABLE `�s�V` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
19
CREATE TABLE `�s�W` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
20
CREATE TABLE `�s�X` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
25
21
INSERT INTO `�s�P` VALUES ('�����');
26
22
INSERT INTO `�s�P` VALUES ('����� ');
27
23
INSERT INTO `�s�P` VALUES ('����� ');
85
81
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�@');
86
82
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�@�@');
87
83
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�@�@�@');
88
INSERT INTO `�s�P�O` VALUES ('�����');
89
INSERT INTO `�s�P�O` VALUES ('����� ');
90
INSERT INTO `�s�P�O` VALUES ('����� ');
91
INSERT INTO `�s�P�O` VALUES ('����� ');
92
INSERT INTO `�s�P�O` VALUES ('������@');
93
INSERT INTO `�s�P�O` VALUES ('������@�@');
94
INSERT INTO `�s�P�O` VALUES ('������@�@�@');
95
INSERT INTO `�s�P�P` VALUES ('����������');
96
INSERT INTO `�s�P�P` VALUES ('���������� ');
97
INSERT INTO `�s�P�P` VALUES ('���������� ');
98
INSERT INTO `�s�P�P` VALUES ('���������� ');
99
INSERT INTO `�s�P�P` VALUES ('�����������@');
100
INSERT INTO `�s�P�P` VALUES ('�����������@�@');
101
INSERT INTO `�s�P�P` VALUES ('�����������@�@�@');
102
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\');
103
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\ ');
104
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\ ');
105
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\ ');
106
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�@');
107
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�@�@');
108
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�@�@�@');
109
84
SELECT RTRIM(`�b�P`) from `�s�P`;