Re: LOAD DATA INFILE and Skipping Columns?
Dr. No wrote:
> Thanks for the advice. My problem is that I am dealing with several GB of data that I will need
> to upload frequently. Therefore creating temporary files or temporary tables is a time consuming
> task.
Have you looked into mysqlimport? Using this tool you could pipe your input file through your filter
without the need for temporary files or tables, like e.g.:
$ cat foo | yourfilter | mysqlimport --local -uuser -ppassword --fields-terminated-by=, test foo
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Written By
Posted
Re: LOAD DATA INFILE and Skipping Columns?
May 09, 2005 06:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.