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 = utf8;
12
CREATE TABLE `Ｔ１` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = innodb;
13
CREATE TABLE `Ｔ２` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = innodb;
14
CREATE TABLE `Ｔ３` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = innodb;
15
CREATE TABLE `Ｔ４` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam;
16
CREATE TABLE `Ｔ５` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam;
17
CREATE TABLE `Ｔ６` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam;
18
CREATE TABLE `Ｔ７` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = MEMORY;
19
CREATE TABLE `Ｔ８` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = MEMORY;
20
CREATE TABLE `Ｔ９` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = MEMORY;
21
INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵ'),('ｱｲｳｴ'),('ｱｲｳ'),('ｱｲ'),('ｱ'),('');
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
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,0) FROM `Ｔ１`;
38
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1) FROM `Ｔ１`;
46
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,2) FROM `Ｔ１`;
54
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,3) FROM `Ｔ１`;
62
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,4) FROM `Ｔ１`;
70
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,5) FROM `Ｔ１`;
78
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,6) FROM `Ｔ１`;
86
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 0) FROM `Ｔ１`;
87
Ｃ１ SUBSTRING(`Ｃ１` FROM 0)
94
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1) FROM `Ｔ１`;
95
Ｃ１ SUBSTRING(`Ｃ１` FROM 1)
102
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 2) FROM `Ｔ１`;
103
Ｃ１ SUBSTRING(`Ｃ１` FROM 2)
110
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 3) FROM `Ｔ１`;
111
Ｃ１ SUBSTRING(`Ｃ１` FROM 3)
118
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 4) FROM `Ｔ１`;
119
Ｃ１ SUBSTRING(`Ｃ１` FROM 4)
126
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ１`;
127
Ｃ１ SUBSTRING(`Ｃ１` FROM 5)
134
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ１`;
135
Ｃ１ SUBSTRING(`Ｃ１` FROM 6)
142
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ１`;
143
Ｃ１ SUBSTRING(`Ｃ１`,1,0)
150
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ１`;
151
Ｃ１ SUBSTRING(`Ｃ１`,1,1)
158
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ１`;
159
Ｃ１ SUBSTRING(`Ｃ１`,1,2)
166
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ１`;
167
Ｃ１ SUBSTRING(`Ｃ１`,1,3)
174
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ１`;
175
Ｃ１ SUBSTRING(`Ｃ１`,1,4)
182
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ１`;
183
Ｃ１ SUBSTRING(`Ｃ１`,1,5)
190
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ１`;
191
Ｃ１ SUBSTRING(`Ｃ１`,1,6)
198
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ１`;
199
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 0)
206
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ１`;
207
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 1)
214
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ１`;
215
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 2)
222
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ１`;
223
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 3)
230
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ１`;
231
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 4)
238
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ１`;
239
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 5)
246
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ１`;
247
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 6)
254
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,0) FROM `Ｔ２`;
262
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1) FROM `Ｔ２`;
270
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,2) FROM `Ｔ２`;
278
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,3) FROM `Ｔ２`;
286
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,4) FROM `Ｔ２`;
294
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,5) FROM `Ｔ２`;
302
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,6) FROM `Ｔ２`;
310
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 0) FROM `Ｔ２`;
311
Ｃ１ SUBSTRING(`Ｃ１` FROM 0)
318
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1) FROM `Ｔ２`;
319
Ｃ１ SUBSTRING(`Ｃ１` FROM 1)
326
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 2) FROM `Ｔ２`;
327
Ｃ１ SUBSTRING(`Ｃ１` FROM 2)
334
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 3) FROM `Ｔ２`;
335
Ｃ１ SUBSTRING(`Ｃ１` FROM 3)
342
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 4) FROM `Ｔ２`;
343
Ｃ１ SUBSTRING(`Ｃ１` FROM 4)
350
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ２`;
351
Ｃ１ SUBSTRING(`Ｃ１` FROM 5)
358
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ２`;
359
Ｃ１ SUBSTRING(`Ｃ１` FROM 6)
366
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ２`;
367
Ｃ１ SUBSTRING(`Ｃ１`,1,0)
374
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ２`;
375
Ｃ１ SUBSTRING(`Ｃ１`,1,1)
382
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ２`;
383
Ｃ１ SUBSTRING(`Ｃ１`,1,2)
390
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ２`;
391
Ｃ１ SUBSTRING(`Ｃ１`,1,3)
398
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ２`;
399
Ｃ１ SUBSTRING(`Ｃ１`,1,4)
406
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ２`;
407
Ｃ１ SUBSTRING(`Ｃ１`,1,5)
414
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ２`;
415
Ｃ１ SUBSTRING(`Ｃ１`,1,6)
422
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ２`;
423
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 0)
430
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ２`;
431
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 1)
438
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ２`;
439
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 2)
446
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ２`;
447
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 3)
454
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ２`;
455
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 4)
462
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ２`;
463
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 5)
470
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ２`;
471
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 6)
478
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,0) FROM `Ｔ３`;
486
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1) FROM `Ｔ３`;
494
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,2) FROM `Ｔ３`;
502
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,3) FROM `Ｔ３`;
510
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,4) FROM `Ｔ３`;
518
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,5) FROM `Ｔ３`;
526
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,6) FROM `Ｔ３`;
534
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 0) FROM `Ｔ３`;
535
Ｃ１ SUBSTRING(`Ｃ１` FROM 0)
542
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1) FROM `Ｔ３`;
543
Ｃ１ SUBSTRING(`Ｃ１` FROM 1)
550
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 2) FROM `Ｔ３`;
551
Ｃ１ SUBSTRING(`Ｃ１` FROM 2)
558
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 3) FROM `Ｔ３`;
559
Ｃ１ SUBSTRING(`Ｃ１` FROM 3)
566
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 4) FROM `Ｔ３`;
567
Ｃ１ SUBSTRING(`Ｃ１` FROM 4)
574
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ３`;
575
Ｃ１ SUBSTRING(`Ｃ１` FROM 5)
582
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ３`;
583
Ｃ１ SUBSTRING(`Ｃ１` FROM 6)
590
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ３`;
591
Ｃ１ SUBSTRING(`Ｃ１`,1,0)
598
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ３`;
599
Ｃ１ SUBSTRING(`Ｃ１`,1,1)
606
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ３`;
607
Ｃ１ SUBSTRING(`Ｃ１`,1,2)
614
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ３`;
615
Ｃ１ SUBSTRING(`Ｃ１`,1,3)
622
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ３`;
623
Ｃ１ SUBSTRING(`Ｃ１`,1,4)
630
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ３`;
631
Ｃ１ SUBSTRING(`Ｃ１`,1,5)
638
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ３`;
639
Ｃ１ SUBSTRING(`Ｃ１`,1,6)
646
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ３`;
647
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 0)
654
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ３`;
655
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 1)
662
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ３`;
663
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 2)
670
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ３`;
671
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 3)
678
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ３`;
679
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 4)
686
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ３`;
687
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 5)
694
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ３`;
695
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 6)
702
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,0) FROM `Ｔ４`;
710
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1) FROM `Ｔ４`;
718
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,2) FROM `Ｔ４`;
726
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,3) FROM `Ｔ４`;
734
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,4) FROM `Ｔ４`;
742
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,5) FROM `Ｔ４`;
750
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,6) FROM `Ｔ４`;
758
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 0) FROM `Ｔ４`;
759
Ｃ１ SUBSTRING(`Ｃ１` FROM 0)
766
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1) FROM `Ｔ４`;
767
Ｃ１ SUBSTRING(`Ｃ１` FROM 1)
774
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 2) FROM `Ｔ４`;
775
Ｃ１ SUBSTRING(`Ｃ１` FROM 2)
782
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 3) FROM `Ｔ４`;
783
Ｃ１ SUBSTRING(`Ｃ１` FROM 3)
790
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 4) FROM `Ｔ４`;
791
Ｃ１ SUBSTRING(`Ｃ１` FROM 4)
798
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ４`;
799
Ｃ１ SUBSTRING(`Ｃ１` FROM 5)
806
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ４`;
807
Ｃ１ SUBSTRING(`Ｃ１` FROM 6)
814
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ４`;
815
Ｃ１ SUBSTRING(`Ｃ１`,1,0)
822
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ４`;
823
Ｃ１ SUBSTRING(`Ｃ１`,1,1)
830
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ４`;
831
Ｃ１ SUBSTRING(`Ｃ１`,1,2)
838
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ４`;
839
Ｃ１ SUBSTRING(`Ｃ１`,1,3)
846
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ４`;
847
Ｃ１ SUBSTRING(`Ｃ１`,1,4)
854
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ４`;
855
Ｃ１ SUBSTRING(`Ｃ１`,1,5)
862
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ４`;
863
Ｃ１ SUBSTRING(`Ｃ１`,1,6)
870
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ４`;
871
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 0)
878
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ４`;
879
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 1)
886
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ４`;
887
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 2)
894
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ４`;
895
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 3)
902
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ４`;
903
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 4)
910
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ４`;
911
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 5)
918
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ４`;
919
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 6)
926
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,0) FROM `Ｔ５`;
934
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1) FROM `Ｔ５`;
942
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,2) FROM `Ｔ５`;
950
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,3) FROM `Ｔ５`;
958
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,4) FROM `Ｔ５`;
966
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,5) FROM `Ｔ５`;
974
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,6) FROM `Ｔ５`;
982
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 0) FROM `Ｔ５`;
983
Ｃ１ SUBSTRING(`Ｃ１` FROM 0)
990
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1) FROM `Ｔ５`;
991
Ｃ１ SUBSTRING(`Ｃ１` FROM 1)
998
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 2) FROM `Ｔ５`;
999
Ｃ１ SUBSTRING(`Ｃ１` FROM 2)
1006
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 3) FROM `Ｔ５`;
1007
Ｃ１ SUBSTRING(`Ｃ１` FROM 3)
1014
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 4) FROM `Ｔ５`;
1015
Ｃ１ SUBSTRING(`Ｃ１` FROM 4)
1022
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ５`;
1023
Ｃ１ SUBSTRING(`Ｃ１` FROM 5)
1030
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ５`;
1031
Ｃ１ SUBSTRING(`Ｃ１` FROM 6)
1038
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ５`;
1039
Ｃ１ SUBSTRING(`Ｃ１`,1,0)
1046
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ５`;
1047
Ｃ１ SUBSTRING(`Ｃ１`,1,1)
1054
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ５`;
1055
Ｃ１ SUBSTRING(`Ｃ１`,1,2)
1062
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ５`;
1063
Ｃ１ SUBSTRING(`Ｃ１`,1,3)
1070
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ５`;
1071
Ｃ１ SUBSTRING(`Ｃ１`,1,4)
1078
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ５`;
1079
Ｃ１ SUBSTRING(`Ｃ１`,1,5)
1086
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ５`;
1087
Ｃ１ SUBSTRING(`Ｃ１`,1,6)
1094
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ５`;
1095
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 0)
1102
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ５`;
1103
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 1)
1110
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ５`;
1111
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 2)
1118
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ５`;
1119
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 3)
1126
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ５`;
1127
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 4)
1134
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ５`;
1135
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 5)
1142
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ５`;
1143
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 6)
1150
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,0) FROM `Ｔ６`;
1151
Ｃ１ SUBSTRING(`Ｃ１`,0)
1158
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1) FROM `Ｔ６`;
1159
Ｃ１ SUBSTRING(`Ｃ１`,1)
1166
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,2) FROM `Ｔ６`;
1167
Ｃ１ SUBSTRING(`Ｃ１`,2)
1174
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,3) FROM `Ｔ６`;
1175
Ｃ１ SUBSTRING(`Ｃ１`,3)
1182
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,4) FROM `Ｔ６`;
1183
Ｃ１ SUBSTRING(`Ｃ１`,4)
1190
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,5) FROM `Ｔ６`;
1191
Ｃ１ SUBSTRING(`Ｃ１`,5)
1198
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,6) FROM `Ｔ６`;
1199
Ｃ１ SUBSTRING(`Ｃ１`,6)
1206
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 0) FROM `Ｔ６`;
1207
Ｃ１ SUBSTRING(`Ｃ１` FROM 0)
1214
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1) FROM `Ｔ６`;
1215
Ｃ１ SUBSTRING(`Ｃ１` FROM 1)
1222
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 2) FROM `Ｔ６`;
1223
Ｃ１ SUBSTRING(`Ｃ１` FROM 2)
1230
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 3) FROM `Ｔ６`;
1231
Ｃ１ SUBSTRING(`Ｃ１` FROM 3)
1238
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 4) FROM `Ｔ６`;
1239
Ｃ１ SUBSTRING(`Ｃ１` FROM 4)
1246
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ６`;
1247
Ｃ１ SUBSTRING(`Ｃ１` FROM 5)
1254
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ６`;
1255
Ｃ１ SUBSTRING(`Ｃ１` FROM 6)
1262
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ６`;
1263
Ｃ１ SUBSTRING(`Ｃ１`,1,0)
1270
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ６`;
1271
Ｃ１ SUBSTRING(`Ｃ１`,1,1)
1278
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ６`;
1279
Ｃ１ SUBSTRING(`Ｃ１`,1,2)
1286
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ６`;
1287
Ｃ１ SUBSTRING(`Ｃ１`,1,3)
1294
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ６`;
1295
Ｃ１ SUBSTRING(`Ｃ１`,1,4)
1302
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ６`;
1303
Ｃ１ SUBSTRING(`Ｃ１`,1,5)
1310
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ６`;
1311
Ｃ１ SUBSTRING(`Ｃ１`,1,6)
1318
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ６`;
1319
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 0)
1326
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ６`;
1327
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 1)
1334
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ６`;
1335
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 2)
1342
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ６`;
1343
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 3)
1350
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ６`;
1351
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 4)
1358
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ６`;
1359
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 5)
1366
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ６`;
1367
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 6)
1374
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,0) FROM `Ｔ７`;
1375
Ｃ１ SUBSTRING(`Ｃ１`,0)
1382
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1) FROM `Ｔ７`;
1383
Ｃ１ SUBSTRING(`Ｃ１`,1)
1390
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,2) FROM `Ｔ７`;
1391
Ｃ１ SUBSTRING(`Ｃ１`,2)
1398
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,3) FROM `Ｔ７`;
1399
Ｃ１ SUBSTRING(`Ｃ１`,3)
1406
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,4) FROM `Ｔ７`;
1407
Ｃ１ SUBSTRING(`Ｃ１`,4)
1414
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,5) FROM `Ｔ７`;
1415
Ｃ１ SUBSTRING(`Ｃ１`,5)
1422
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,6) FROM `Ｔ７`;
1423
Ｃ１ SUBSTRING(`Ｃ１`,6)
1430
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 0) FROM `Ｔ７`;
1431
Ｃ１ SUBSTRING(`Ｃ１` FROM 0)
1438
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1) FROM `Ｔ７`;
1439
Ｃ１ SUBSTRING(`Ｃ１` FROM 1)
1446
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 2) FROM `Ｔ７`;
1447
Ｃ１ SUBSTRING(`Ｃ１` FROM 2)
1454
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 3) FROM `Ｔ７`;
1455
Ｃ１ SUBSTRING(`Ｃ１` FROM 3)
1462
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 4) FROM `Ｔ７`;
1463
Ｃ１ SUBSTRING(`Ｃ１` FROM 4)
1470
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ７`;
1471
Ｃ１ SUBSTRING(`Ｃ１` FROM 5)
1478
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ７`;
1479
Ｃ１ SUBSTRING(`Ｃ１` FROM 6)
1486
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ７`;
1487
Ｃ１ SUBSTRING(`Ｃ１`,1,0)
1494
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ７`;
1495
Ｃ１ SUBSTRING(`Ｃ１`,1,1)
1502
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ７`;
1503
Ｃ１ SUBSTRING(`Ｃ１`,1,2)
1510
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ７`;
1511
Ｃ１ SUBSTRING(`Ｃ１`,1,3)
1518
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ７`;
1519
Ｃ１ SUBSTRING(`Ｃ１`,1,4)
1526
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ７`;
1527
Ｃ１ SUBSTRING(`Ｃ１`,1,5)
1534
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ７`;
1535
Ｃ１ SUBSTRING(`Ｃ１`,1,6)
1542
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ７`;
1543
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 0)
1550
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ７`;
1551
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 1)
1558
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ７`;
1559
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 2)
1566
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ７`;
1567
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 3)
1574
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ７`;
1575
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 4)
1582
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ７`;
1583
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 5)
1590
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ７`;
1591
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 6)
1598
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,0) FROM `Ｔ８`;
1599
Ｃ１ SUBSTRING(`Ｃ１`,0)
1606
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1) FROM `Ｔ８`;
1607
Ｃ１ SUBSTRING(`Ｃ１`,1)
1614
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,2) FROM `Ｔ８`;
1615
Ｃ１ SUBSTRING(`Ｃ１`,2)
1622
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,3) FROM `Ｔ８`;
1623
Ｃ１ SUBSTRING(`Ｃ１`,3)
1630
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,4) FROM `Ｔ８`;
1631
Ｃ１ SUBSTRING(`Ｃ１`,4)
1638
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,5) FROM `Ｔ８`;
1639
Ｃ１ SUBSTRING(`Ｃ１`,5)
1646
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,6) FROM `Ｔ８`;
1647
Ｃ１ SUBSTRING(`Ｃ１`,6)
1654
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 0) FROM `Ｔ８`;
1655
Ｃ１ SUBSTRING(`Ｃ１` FROM 0)
1662
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1) FROM `Ｔ８`;
1663
Ｃ１ SUBSTRING(`Ｃ１` FROM 1)
1670
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 2) FROM `Ｔ８`;
1671
Ｃ１ SUBSTRING(`Ｃ１` FROM 2)
1678
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 3) FROM `Ｔ８`;
1679
Ｃ１ SUBSTRING(`Ｃ１` FROM 3)
1686
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 4) FROM `Ｔ８`;
1687
Ｃ１ SUBSTRING(`Ｃ１` FROM 4)
1694
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ８`;
1695
Ｃ１ SUBSTRING(`Ｃ１` FROM 5)
1702
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ８`;
1703
Ｃ１ SUBSTRING(`Ｃ１` FROM 6)
1710
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ８`;
1711
Ｃ１ SUBSTRING(`Ｃ１`,1,0)
1718
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ８`;
1719
Ｃ１ SUBSTRING(`Ｃ１`,1,1)
1726
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ８`;
1727
Ｃ１ SUBSTRING(`Ｃ１`,1,2)
1734
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ８`;
1735
Ｃ１ SUBSTRING(`Ｃ１`,1,3)
1742
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ８`;
1743
Ｃ１ SUBSTRING(`Ｃ１`,1,4)
1750
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ８`;
1751
Ｃ１ SUBSTRING(`Ｃ１`,1,5)
1758
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ８`;
1759
Ｃ１ SUBSTRING(`Ｃ１`,1,6)
1766
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ８`;
1767
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 0)
1774
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ８`;
1775
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 1)
1782
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ８`;
1783
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 2)
1790
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ８`;
1791
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 3)
1798
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ８`;
1799
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 4)
1806
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ８`;
1807
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 5)
1814
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ８`;
1815
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 6)
1822
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,0) FROM `Ｔ９`;
1823
Ｃ１ SUBSTRING(`Ｃ１`,0)
1830
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1) FROM `Ｔ９`;
1831
Ｃ１ SUBSTRING(`Ｃ１`,1)
1838
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,2) FROM `Ｔ９`;
1839
Ｃ１ SUBSTRING(`Ｃ１`,2)
1846
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,3) FROM `Ｔ９`;
1847
Ｃ１ SUBSTRING(`Ｃ１`,3)
1854
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,4) FROM `Ｔ９`;
1855
Ｃ１ SUBSTRING(`Ｃ１`,4)
1862
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,5) FROM `Ｔ９`;
1863
Ｃ１ SUBSTRING(`Ｃ１`,5)
1870
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,6) FROM `Ｔ９`;
1871
Ｃ１ SUBSTRING(`Ｃ１`,6)
1878
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 0) FROM `Ｔ９`;
1879
Ｃ１ SUBSTRING(`Ｃ１` FROM 0)
1886
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1) FROM `Ｔ９`;
1887
Ｃ１ SUBSTRING(`Ｃ１` FROM 1)
1894
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 2) FROM `Ｔ９`;
1895
Ｃ１ SUBSTRING(`Ｃ１` FROM 2)
1902
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 3) FROM `Ｔ９`;
1903
Ｃ１ SUBSTRING(`Ｃ１` FROM 3)
1910
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 4) FROM `Ｔ９`;
1911
Ｃ１ SUBSTRING(`Ｃ１` FROM 4)
1918
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ９`;
1919
Ｃ１ SUBSTRING(`Ｃ１` FROM 5)
1926
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ９`;
1927
Ｃ１ SUBSTRING(`Ｃ１` FROM 6)
1934
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ９`;
1935
Ｃ１ SUBSTRING(`Ｃ１`,1,0)
1942
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ９`;
1943
Ｃ１ SUBSTRING(`Ｃ１`,1,1)
1950
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ９`;
1951
Ｃ１ SUBSTRING(`Ｃ１`,1,2)
1958
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ９`;
1959
Ｃ１ SUBSTRING(`Ｃ１`,1,3)
1966
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ９`;
1967
Ｃ１ SUBSTRING(`Ｃ１`,1,4)
1974
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ９`;
1975
Ｃ１ SUBSTRING(`Ｃ１`,1,5)
1982
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ９`;
1983
Ｃ１ SUBSTRING(`Ｃ１`,1,6)
1990
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ９`;
1991
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 0)
1998
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ９`;
1999
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 1)
2006
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ９`;
2007
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 2)
2014
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ９`;
2015
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 3)
2022
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ９`;
2023
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 4)
2030
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ９`;
2031
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 5)
2038
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ９`;
2039
Ｃ１ SUBSTRING(`Ｃ１` FROM 1 FOR 6)
added
removed
mysql-test/suite/jp/r/jp_substring_utf8.result
