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(8), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
13 CREATE TABLE `‚s‚Q` (`‚b‚P` char(8), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
14 CREATE TABLE `‚s‚R` (`‚b‚P` char(8), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
15 CREATE TABLE `‚s‚S` (`‚b‚P` char(8), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
16 CREATE TABLE `‚s‚T` (`‚b‚P` char(8), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
17 CREATE TABLE `‚s‚U` (`‚b‚P` char(8), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
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;
21 INSERT INTO `‚s‚P` VALUES ('±²³´µ');
22 INSERT INTO `‚s‚P` VALUES (' ±²³´µ');
23 INSERT INTO `‚s‚P` VALUES (' ±²³´µ');
24 INSERT INTO `‚s‚P` VALUES (' ±²³´µ');
25 INSERT INTO `‚s‚P` VALUES ('�@±²³´µ');
26 INSERT INTO `‚s‚P` VALUES ('�@�@±²³´µ');
27 INSERT INTO `‚s‚P` VALUES ('�@�@�@±²³´µ');
28 INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨');
29 INSERT INTO `‚s‚Q` VALUES (' ‚ ‚¢‚¤‚¦‚¨');
30 INSERT INTO `‚s‚Q` VALUES (' ‚ ‚¢‚¤‚¦‚¨');
31 INSERT INTO `‚s‚Q` VALUES (' ‚ ‚¢‚¤‚¦‚¨');
32 INSERT INTO `‚s‚Q` VALUES ('�@‚ ‚¢‚¤‚¦‚¨');
33 INSERT INTO `‚s‚Q` VALUES ('�@�@‚ ‚¢‚¤‚¦‚¨');
34 INSERT INTO `‚s‚Q` VALUES ('�@�@�@‚ ‚¢‚¤‚¦‚¨');
35 INSERT INTO `‚s‚R` VALUES ('ƒ\�\•\—\�\');
36 INSERT INTO `‚s‚R` VALUES (' ƒ\�\•\—\�\');
37 INSERT INTO `‚s‚R` VALUES (' ƒ\�\•\—\�\');
38 INSERT INTO `‚s‚R` VALUES (' ƒ\�\•\—\�\');
39 INSERT INTO `‚s‚R` VALUES ('�@ƒ\�\•\—\�\');
40 INSERT INTO `‚s‚R` VALUES ('�@�@ƒ\�\•\—\�\');
41 INSERT INTO `‚s‚R` VALUES ('�@�@�@ƒ\�\•\—\�\');
42 INSERT INTO `‚s‚S` VALUES ('±²³´µ');
43 INSERT INTO `‚s‚S` VALUES (' ±²³´µ');
44 INSERT INTO `‚s‚S` VALUES (' ±²³´µ');
45 INSERT INTO `‚s‚S` VALUES (' ±²³´µ');
46 INSERT INTO `‚s‚S` VALUES ('�@±²³´µ');
47 INSERT INTO `‚s‚S` VALUES ('�@�@±²³´µ');
48 INSERT INTO `‚s‚S` VALUES ('�@�@�@±²³´µ');
49 INSERT INTO `‚s‚T` VALUES ('‚ ‚¢‚¤‚¦‚¨');
50 INSERT INTO `‚s‚T` VALUES (' ‚ ‚¢‚¤‚¦‚¨');
51 INSERT INTO `‚s‚T` VALUES (' ‚ ‚¢‚¤‚¦‚¨');
52 INSERT INTO `‚s‚T` VALUES (' ‚ ‚¢‚¤‚¦‚¨');
53 INSERT INTO `‚s‚T` VALUES ('�@‚ ‚¢‚¤‚¦‚¨');
54 INSERT INTO `‚s‚T` VALUES ('�@�@‚ ‚¢‚¤‚¦‚¨');
55 INSERT INTO `‚s‚T` VALUES ('�@�@�@‚ ‚¢‚¤‚¦‚¨');
56 INSERT INTO `‚s‚U` VALUES ('ƒ\�\•\—\�\');
57 INSERT INTO `‚s‚U` VALUES (' ƒ\�\•\—\�\');
58 INSERT INTO `‚s‚U` VALUES (' ƒ\�\•\—\�\');
59 INSERT INTO `‚s‚U` VALUES (' ƒ\�\•\—\�\');
60 INSERT INTO `‚s‚U` VALUES ('�@ƒ\�\•\—\�\');
61 INSERT INTO `‚s‚U` VALUES ('�@�@ƒ\�\•\—\�\');
62 INSERT INTO `‚s‚U` VALUES ('�@�@�@ƒ\�\•\—\�\');
63 INSERT INTO `‚s‚V` VALUES ('±²³´µ');
64 INSERT INTO `‚s‚V` VALUES (' ±²³´µ');
65 INSERT INTO `‚s‚V` VALUES (' ±²³´µ');
66 INSERT INTO `‚s‚V` VALUES (' ±²³´µ');
67 INSERT INTO `‚s‚V` VALUES ('�@±²³´µ');
68 INSERT INTO `‚s‚V` VALUES ('�@�@±²³´µ');
69 INSERT INTO `‚s‚V` VALUES ('�@�@�@±²³´µ');
70 INSERT INTO `‚s‚W` VALUES ('‚ ‚¢‚¤‚¦‚¨');
71 INSERT INTO `‚s‚W` VALUES (' ‚ ‚¢‚¤‚¦‚¨');
72 INSERT INTO `‚s‚W` VALUES (' ‚ ‚¢‚¤‚¦‚¨');
73 INSERT INTO `‚s‚W` VALUES (' ‚ ‚¢‚¤‚¦‚¨');
74 INSERT INTO `‚s‚W` VALUES ('�@‚ ‚¢‚¤‚¦‚¨');
75 INSERT INTO `‚s‚W` VALUES ('�@�@‚ ‚¢‚¤‚¦‚¨');
76 INSERT INTO `‚s‚W` VALUES ('�@�@�@‚ ‚¢‚¤‚¦‚¨');
77 INSERT INTO `‚s‚X` VALUES ('ƒ\�\•\—\�\');
78 INSERT INTO `‚s‚X` VALUES (' ƒ\�\•\—\�\');
79 INSERT INTO `‚s‚X` VALUES (' ƒ\�\•\—\�\');
80 INSERT INTO `‚s‚X` VALUES (' ƒ\�\•\—\�\');
81 INSERT INTO `‚s‚X` VALUES ('�@ƒ\�\•\—\�\');
82 INSERT INTO `‚s‚X` VALUES ('�@�@ƒ\�\•\—\�\');
83 INSERT INTO `‚s‚X` VALUES ('�@�@�@ƒ\�\•\—\�\');
84 SELECT LTRIM(`‚b‚P`) from `‚s‚P`;
93 SELECT LTRIM(`‚b‚P`) from `‚s‚Q`;
102 SELECT LTRIM(`‚b‚P`) from `‚s‚R`;
111 SELECT LTRIM(`‚b‚P`) from `‚s‚S`;
120 SELECT LTRIM(`‚b‚P`) from `‚s‚T`;
129 SELECT LTRIM(`‚b‚P`) from `‚s‚U`;
138 SELECT LTRIM(`‚b‚P`) from `‚s‚V`;
147 SELECT LTRIM(`‚b‚P`) from `‚s‚W`;
156 SELECT LTRIM(`‚b‚P`) from `‚s‚X`;