I've run into a problem when inserting a textfile (.csv) into a table. The .csv file inserts, but the entries in the last column insert with a blank space folling the entry. For example, if the table has 3 columns (Name, Rank, SerialNumber), the file insert with a blank space after SerialNumber (or "SerialNumber "). This caused me a headache when I was trying to get a PHP/MySql generated javascript menu to run.
I'm using phpMyAdmin 2.0.1 with MySQL 3.22.27.
There is no blank space in the text file entries. Am I doing something wrong?
I'm using phpMyAdmin 2.0.1 with MySQL 3.22.27.
There is no blank space in the text file entries. Am I doing something wrong?