I'm importing transaction files from a text file to a MySQL database, and something strange that has never happened to me is happening. I'm working in Sequel Pro, and when importing the file, it is ignoring the first column of the text file for every entry after the first. Every other column shifts left and is screwing up the import. I've attempted to delete the column, but the same thing happens. It shifts left after the first entry.

Have you tried running it through a script to remove leading/trailing whitespace from each line?
–
AJ.Jun 13 '11 at 13:35

What IS the first column? What does it contain? What field type is it?
–
itsolsJun 13 '11 at 13:40

The first column is a char to designate which store. It is a single character, in quotes. The next few columns are integers. Since everything is shifting left and the integers are not in quotes, the first column is coming up blank in the second-last columns, and the second column is the information from the third. I've checked the text file, there are no leading spaces.
–
maxman92Jun 13 '11 at 13:49

How does 'Sequel Pro' import the data in? Is it possibly considering the first column as the primary key (hiding it)?
–
John MJun 13 '11 at 15:46

It does not. Strangely enough, I've imported this file (and ones like it with the same format) many times in the past without a hitch. Exactly the same method each time and today is the first time having such an issue.
–
maxman92Jun 13 '11 at 17:07