RE: Import CSV file into MySQL table via phpMyAdmin

[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

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

import CSV

can any one help is there a way where i can import a csv file into multiple tables in MySQL database this has to be a run when ever there is a file in a wating directory thanks in advance == Disclaimer Notice This message

file not found error when trying to import CSV to database table

Hello, I am painfully new to mySQL (I'm working on my first database), so my apologies if I ask something stupid. I am using phpMyAdmin 2.2.0 to connect to MySQL 3.23.36 I have a database named "aro" with a table "specialdays" I have a CSV that I want to import to the 'specialdays' I wen