I have a field in my database table ("describe" output to follow) used to store the 10 digits of a phone number. When I attempt to load data into this table from a delimited textfile, the numbers in 90% of the records in this column are set to a number that appears NOWHERE in either the textfile or the SQL statement. How is this possible and is there a solution???
Here's the table description:
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| fname | varchar(24) | YES | | NULL | |
| lname | varchar(24) | YES | | NULL | |
| bus_name | varchar(64) | YES | | NULL | |
| addr1 | varchar(32) | YES | | NULL | |
| addr2 | varchar(32) | YES | | NULL | |
| city | varchar(32) | YES | | NULL | |
| state | char(2) | YES | | NULL | |
| zip | int(5) | YES | | NULL | |
| tele | int(25) | YES | | NULL | |
| dlr_no | int(6) | | PRI | 0 | |
+----------+-------------+------+-----+---------+-------+
Here's the table description:
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| fname | varchar(24) | YES | | NULL | |
| lname | varchar(24) | YES | | NULL | |
| bus_name | varchar(64) | YES | | NULL | |
| addr1 | varchar(32) | YES | | NULL | |
| addr2 | varchar(32) | YES | | NULL | |
| city | varchar(32) | YES | | NULL | |
| state | char(2) | YES | | NULL | |
| zip | int(5) | YES | | NULL | |
| tele | int(25) | YES | | NULL | |
| dlr_no | int(6) | | PRI | 0 | |
+----------+-------------+------+-----+---------+-------+