1 drop table if exists `£Ô£±`;
2 drop table if exists `£Ô£²`;
3 drop table if exists `£Ô£³`;
4 drop table if exists `£Ô£´`;
5 drop table if exists `£Ô£µ`;
6 drop table if exists `£Ô£¶`;
7 drop table if exists `£Ô£·`;
8 drop table if exists `£Ô£¸`;
9 drop table if exists `£Ô£¹`;
11 SET character_set_database = ucs2;
12 SET collation_connection = ucs2_general_ci;
13 CREATE TABLE `£Ô£±` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = innodb;
14 CREATE TABLE `£Ô£²` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = innodb;
15 CREATE TABLE `£Ô£³` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = innodb;
16 CREATE TABLE `£Ô£´` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = myisam;
17 CREATE TABLE `£Ô£µ` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = myisam;
18 CREATE TABLE `£Ô£¶` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = myisam;
19 CREATE TABLE `£Ô£·` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = MEMORY;
20 CREATE TABLE `£Ô£¸` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = MEMORY;
21 CREATE TABLE `£Ô£¹` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = MEMORY;
22 INSERT INTO `£Ô£±` VALUES ('Ž±Ž²Ž³Ž´Žµ'),('Ž±Ž²Ž³Ž´'),('Ž±Ž²Ž³'),('Ž±Ž²'),('Ž±'),('');
23 INSERT INTO `£Ô£²` VALUES ('¤¢¤¤¤¦¤¨¤ª'),('¤¢¤¤¤¦¤¨'),('¤¢¤¤¤¦'),('¤¢¤¤'),('¤¢'),('');
24 INSERT INTO `£Ô£³` VALUES ('�íÜ�íÝ�íÞ�íß�íà'),('�íÜ�íÝ�íÞ�íß'),('�íÜ�íÝ�íÞ'),('�íÜ�íÝ'),('�íÜ'),('');
25 INSERT INTO `£Ô£´` VALUES ('Ž±Ž²Ž³Ž´Žµ'),('Ž±Ž²Ž³Ž´'),('Ž±Ž²Ž³'),('Ž±Ž²'),('Ž±'),('');
26 INSERT INTO `£Ô£µ` VALUES ('¤¢¤¤¤¦¤¨¤ª'),('¤¢¤¤¤¦¤¨'),('¤¢¤¤¤¦'),('¤¢¤¤'),('¤¢'),('');
27 INSERT INTO `£Ô£¶` VALUES ('�íÜ�íÝ�íÞ�íß�íà'),('�íÜ�íÝ�íÞ�íß'),('�íÜ�íÝ�íÞ'),('�íÜ�íÝ'),('�íÜ'),('');
28 INSERT INTO `£Ô£·` VALUES ('Ž±Ž²Ž³Ž´Žµ'),('Ž±Ž²Ž³Ž´'),('Ž±Ž²Ž³'),('Ž±Ž²'),('Ž±'),('');
29 INSERT INTO `£Ô£¸` VALUES ('¤¢¤¤¤¦¤¨¤ª'),('¤¢¤¤¤¦¤¨'),('¤¢¤¤¤¦'),('¤¢¤¤'),('¤¢'),('');
30 INSERT INTO `£Ô£¹` VALUES ('�íÜ�íÝ�íÞ�íß�íà'),('�íÜ�íÝ�íÞ�íß'),('�íÜ�íÝ�íÞ'),('�íÜ�íÝ'),('�íÜ'),('');
31 SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£±`;
39 SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£±`;
47 SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£±`;
55 SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£±`;
63 SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£±`;
71 SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£±`;
79 SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£²`;
87 SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£²`;
95 SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£²`;
103 SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£²`;
111 SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£²`;
119 SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£²`;
126 ¤¢¤¤¤¦¤¨¤ª ¤¢¤¤¤¦¤¨¤ª
127 SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£³`;
135 SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£³`;
143 SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£³`;
150 �íÜ�íÝ�íÞ�íß�íà �íÜ�íÝ
151 SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£³`;
157 �íÜ�íÝ�íÞ�íß �íÜ�íÝ�íÞ
158 �íÜ�íÝ�íÞ�íß�íà �íÜ�íÝ�íÞ
159 SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£³`;
165 �íÜ�íÝ�íÞ�íß �íÜ�íÝ�íÞ�íß
166 �íÜ�íÝ�íÞ�íß�íà �íÜ�íÝ�íÞ�íß
167 SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£³`;
173 �íÜ�íÝ�íÞ�íß �íÜ�íÝ�íÞ�íß
174 �íÜ�íÝ�íÞ�íß�íà �íÜ�íÝ�íÞ�íß�íà
175 SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£´`;
183 SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£´`;
191 SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£´`;
199 SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£´`;
207 SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£´`;
215 SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£´`;
222 Ž±Ž²Ž³Ž´Žµ Ž±Ž²Ž³Ž´Žµ
223 SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£µ`;
231 SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£µ`;
239 SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£µ`;
247 SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£µ`;
255 SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£µ`;
263 SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£µ`;
270 ¤¢¤¤¤¦¤¨¤ª ¤¢¤¤¤¦¤¨¤ª
271 SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£¶`;
279 SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£¶`;
287 SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£¶`;
294 �íÜ�íÝ�íÞ�íß�íà �íÜ�íÝ
295 SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£¶`;
301 �íÜ�íÝ�íÞ�íß �íÜ�íÝ�íÞ
302 �íÜ�íÝ�íÞ�íß�íà �íÜ�íÝ�íÞ
303 SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£¶`;
309 �íÜ�íÝ�íÞ�íß �íÜ�íÝ�íÞ�íß
310 �íÜ�íÝ�íÞ�íß�íà �íÜ�íÝ�íÞ�íß
311 SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£¶`;
317 �íÜ�íÝ�íÞ�íß �íÜ�íÝ�íÞ�íß
318 �íÜ�íÝ�íÞ�íß�íà �íÜ�íÝ�íÞ�íß�íà
319 SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£·`;
327 SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£·`;
335 SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£·`;
343 SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£·`;
351 SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£·`;
359 SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£·`;
361 Ž±Ž²Ž³Ž´Žµ Ž±Ž²Ž³Ž´Žµ
367 SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£¸`;
375 SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£¸`;
383 SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£¸`;
391 SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£¸`;
399 SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£¸`;
407 SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£¸`;
409 ¤¢¤¤¤¦¤¨¤ª ¤¢¤¤¤¦¤¨¤ª
415 SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£¹`;
423 SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£¹`;
431 SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£¹`;
433 �íÜ�íÝ�íÞ�íß�íà �íÜ�íÝ
439 SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£¹`;
441 �íÜ�íÝ�íÞ�íß�íà �íÜ�íÝ�íÞ
442 �íÜ�íÝ�íÞ�íß �íÜ�íÝ�íÞ
447 SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£¹`;
449 �íÜ�íÝ�íÞ�íß�íà �íÜ�íÝ�íÞ�íß
450 �íÜ�íÝ�íÞ�íß �íÜ�íÝ�íÞ�íß
455 SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£¹`;
457 �íÜ�íÝ�íÞ�íß�íà �íÜ�íÝ�íÞ�íß�íà
458 �íÜ�íÝ�íÞ�íß �íÜ�íÝ�íÞ�íß