|
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
Navigation:
[Reply to this message]
|