[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 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 [/snip] Change Column names: <blank> to name, zip_id, state -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
