Posted by Thomas Bartkus on 11/16/05 18:43

"BigDave" <spam@spam.com> wrote in message
news:dsmdnUVt9KBUsebeRVnyvA@giganews.com...
> Hello,
>
> Can someone suggest a way to import many CSV files into a MySQL table?
> All CSV files are stored in one directory and need to be imported one by
> one.
> This is on a Windows server.

Look up "LOAD DATA INFILE".

OR perhaps the problem that you know how to import CSV files but just don't
know how to script it?

A sequence of "LOAD DATA INFILE" commands, properly terminated by ";", in a
plain text file that you pass to the MySQL utility thus:

mysql -u {username} -p {password} sql_script.txt

Thomas Bartkus

[Back to original message]