18
18
CREATE TEMPORARY TABLE `T9` (`C1` char(20), INDEX(`C1`)) engine = MEMORY;
19
19
LOAD DATA INFILE '../std_data_ln/jisx0201_utf8.dat' INTO TABLE `T1`;
20
20
LOAD DATA INFILE '../std_data_ln/jisx0208_utf8.dat' INTO TABLE `T2`;
23
22
LOAD DATA INFILE '../std_data_ln/jisx0212_utf8.dat' INTO TABLE `T3`;
24
23
LOAD DATA INFILE '../std_data_ln/jisx0201_utf8.dat' INTO TABLE `T4`;
25
24
LOAD DATA INFILE '../std_data_ln/jisx0208_utf8.dat' INTO TABLE `T5`;
28
26
LOAD DATA INFILE '../std_data_ln/jisx0212_utf8.dat' INTO TABLE `T6`;
29
27
LOAD DATA INFILE '../std_data_ln/jisx0201_utf8.dat' INTO TABLE `T7`;
30
28
LOAD DATA INFILE '../std_data_ln/jisx0208_utf8.dat' INTO TABLE `T8`;
33
30
LOAD DATA INFILE '../std_data_ln/jisx0212_utf8.dat' INTO TABLE `T9`;
34
31
SELECT * FROM `T1` WHERE `C1` LIKE ' %';