создаю таблицу
mysql> CREATE TABLE codes (id INT, descr text, prefix INT, l_from INT, l_to INT, oid INT);
Query OK, 0 ROWS affected (0.89 sec)
mysql> LOAD DATA LOCAL INFILE "/home/user/codes.sql" INTO TABLE codes;
Query OK, 3025 ROWS affected, 18150 warnings (0.02 sec)
Records: 3025 Deleted: 0 Skipped: 0 Warnings: 15126
mysql> SELECT * FROM codes LIMIT 10;
+------+-------+--------+--------+------+------+
| id | descr | prefix | l_from | l_to | oid |
+------+-------+--------+--------+------+------+
| 0 | NULL | NULL | NULL | NULL | NULL |
| 0 | NULL | NULL | NULL | NULL | NULL |
| 0 | NULL | NULL | NULL | NULL | NULL |
| 0 | NULL | NULL | NULL | NULL | NULL |
| 0 | NULL | NULL | NULL | NULL | NULL |
| 0 | NULL | NULL | NULL | NULL | NULL |
| 0 | NULL | NULL | NULL | NULL | NULL |
| 0 | NULL | NULL | NULL | NULL | NULL |
| 0 | NULL | NULL | NULL | NULL | NULL |
| 0 | NULL | NULL | NULL | NULL | NULL |
+------+-------+--------+--------+------+------+
10 ROWS IN SET (0.00 sec)
mysql> show warnings;
| Warning | 1366 | Incorrect integer value: '| 2 | Afghanistan Mobile - Roshan | 9379 | 11 | 11 | 1 ' for column 'id' at row 5 |
+----+-----------------------------+--------+--------+------+-----+
| id | descr | prefix | l_from | l_to | oid |
+----+-----------------------------+--------+--------+------+-----+
| 1 | Afghanistan Mobile - Other | 937 | 11 | 11 | 1 |
| 2 | Afghanistan Mobile - Roshan | 9379 | 11 | 11 | 1 |
| 3 | Afghanistan Proper | 93 | 8 | 12 | 1 |
+----+-----------------------------+--------+--------+------+-----+