Comma-separated files to MySQL

[larshgf]

Hi

Does anybody know how to tranfer data from a comma-separated file to a MySQL database table.

Lars, DK

[greg.harvey]

Ach. The MySQL I use has a phpAdmin portal.... I'll have a look at the syntax for you.

G

[greg.harvey]

Ok. phpAdmin spat out the following SQL when I tested it quickly:

LOAD DATA LOCAL INFILE '/home/tmp/phpbLAmAj' INTO TABLE test FIELDS TERMINATED BY ', ' ESCAPED BY '\\' LINES TERMINATED BY '\n'

Sub in what you need really. Obviously, INFILE was created by the server temporarily from the CSV, but I'm assuming that INFILE 'http://www.mysite.com/mycsv.csv' would work just the same. Maybe.

[greg.harvey]

Then again, looking at the options, you'd have to change the LOCAL to something I imagine. Still, now you know the basic command you're after you can check the MySQL documentation.

[larshgf]

Thanks Greg! It works fine.

Lars, DK

[Boss Hoss]

http://www.mysql.com/doc/en/LOAD_DATA.html

How do I pass the file from say a form file field to the SQL statement so I can create a page to upload a file from the desktop and insert into MySQL table?