RE: Import CSV file into MySQL table via phpMyAdmin

2003-08-19 Thread Jay Blanchard
[snip] 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 fie

Import CSV file into MySQL table via phpMyAdmin

2003-08-18 Thread James Johnson
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, st