Unnamed

CREATE TABLE `IBMS_Mart_myisam` (
 `minor_present_contributors` char( 24 ) DEFAULT NULL ,
 `minor_specific_contributors` char( 24 ) DEFAULT NULL ,
 `CL` char( 13 ) NOT NULL DEFAULT '0000000000000',
 `AL` char( 13 ) NOT NULL DEFAULT '0000000000000',
 `SX` char( 6 ) NOT NULL DEFAULT 'AAAAAA',
 `Less_18` char( 1 ) DEFAULT NULL ,
 `Less_14` char( 1 ) DEFAULT NULL ,
 `minor_specific` char( 1 ) DEFAULT NULL ,
 UNIQUE KEY `IBMS_Mart_CL` ( `CL` ) USING BTREE,
 KEY `IBMS_Mart_AL` ( `AL` ) USING BTREE,
 KEY `IBMS_Mart_AL_SX` ( `AL` , `SX` ) USING BTREE
) ENGINE = MyISAM

LOAD DATA CONCURRENT LOCAL INFILE 'IBMS_Mart.csv' INTO TABLE IBMS_Mart_myisam fields terminated by ',' optionally enclosed by '"' lines terminated by '\n';

phpMyAdmin:
Data  	6,829.9  	MiB
Index 	3,113.0 	MiB
Total 	9,942.9 	MiB

mysql> SELECT CL FROM IBMS_Mart_myisam WHERE CL=1234567891234;
Empty set (51.85 sec)


mysql> SHOW INDEX FROM IBMS_Mart_myisam;
+------------------+------------+-----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table            | Non_unique | Key_name        | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+------------------+------------+-----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| IBMS_Mart_myisam |          0 | IBMS_Mart_CL    |            1 | CL          | A         |    85258537 |     NULL | NULL   |      | BTREE      |         |
| IBMS_Mart_myisam |          1 | IBMS_Mart_AL    |            1 | AL          | A         |    42629268 |     NULL | NULL   |      | BTREE      |         |
| IBMS_Mart_myisam |          1 | IBMS_Mart_AL_SX |            1 | AL          | A         |    42629268 |     NULL | NULL   |      | BTREE      |         |
| IBMS_Mart_myisam |          1 | IBMS_Mart_AL_SX |            2 | SX          | A         |    42629268 |     NULL | NULL   |      | BTREE      |         |
+------------------+------------+-----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
4 rows in set (0.00 sec)