Hello, I'm having a problem importing a CSV file into a MySQL table using phpMyAdmin. The DB is on the hosting company server. I'm on WindowsXP, the server is Unix. The table has 6 initial entries, that I'd like to save.
The table is structured as: Table name "campuses" inst_id, name, zip_id, state (inst_id is an auto-increment integer data type) The CSV file has the following format Name, zip, state For example: ACADEMY OF ART COLLEGE,94105,CA In phpMyAdmin I go to SQL -> Insert data from a textfile into table, then fill in the fields with the following values: Location: CSV path/file Replace table data with file: unchecked Fields terminated by: , Fields enclosed by: <blank> Fields escaped by: <blank> Lines terminated by: <blank> Column names: <blank> LOAD method: DATA LOCAL When the data is inserted, the inst_id columns are added, but nothing shows up in name, zip_id, or state. Is there a way via MySQL Admin or the command line that I can transfer from my machine to the server? Thanks, James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
