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 `�ԣ�`;
151
SELECT `�ã�`, LEFT(`�ã�`,3) FROM `�ԣ�`;
159
SELECT `�ã�`, LEFT(`�ã�`,4) FROM `�ԣ�`;
166
���ݏ�ޏ�ߏ�� ���ݏ�ޏ��
167
SELECT `�ã�`, LEFT(`�ã�`,5) FROM `�ԣ�`;
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 `�ԣ�`;
295
SELECT `�ã�`, LEFT(`�ã�`,3) FROM `�ԣ�`;
303
SELECT `�ã�`, LEFT(`�ã�`,4) FROM `�ԣ�`;
310
���ݏ�ޏ�ߏ�� ���ݏ�ޏ��
311
SELECT `�ã�`, LEFT(`�ã�`,5) FROM `�ԣ�`;
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 `�ԣ�`;
439
SELECT `�ã�`, LEFT(`�ã�`,3) FROM `�ԣ�`;
447
SELECT `�ã�`, LEFT(`�ã�`,4) FROM `�ԣ�`;
449
���ݏ�ޏ�ߏ�� ���ݏ�ޏ��
455
SELECT `�ã�`, LEFT(`�ã�`,5) FROM `�ԣ�`;
457
���ݏ�ޏ�ߏ�� ���ݏ�ޏ�ߏ��