Hi,
On May 25, 2005, at 1:28 PM, Jessica Svensson wrote:
That just complicates things alot since i get around 200 files, 6
times a day via an automated process and every textfile looks
different from the other. To just have different load data would make
it much easier.
I have read alot of questions about just this and many people is
asking for this feature. Thats why i'm woundering if it really havent
been impemented in these 5 years that have passed.
The ability to do this was just implemented recently in MySQL 5.0,
along with some other enhancements to LOAD DATA INFILE in 5.0. I don't
think the documentation has been updated yet to include the new
information though. Hopefully it will be soon.
You see the changeset and a preliminary description at
http://lists.mysql.com/internals/23068 That should be able to do what
you want (and more cool stuff!)
Prior to that version, you would have to do as he recommended below
with a separate staging table.
From: Harald Fuchs <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Re: LOAD DATA and skip columns in text file...
Date: 25 May 2005 13:24:55 +0200
In article <[EMAIL PROTECTED]>,
"Jessica Svensson" <[EMAIL PROTECTED]> writes:
> LOAD DATA and skip columns in text file...
> What i have found out is that this is not possible in any existing
> version of mysql, correct?
> I found a message from Sinisa Milivojevic @ MySQL AB dated
06/29/2000
> while searching on google.
> It said "We have entered this on our TODO list one month ago."
> So that would be almost exactly 5 years ago... is it really that
this
> function has not been implemented during these 5 years? If so, then
i
> guess it could be 5 more years before its impelemented and that i
> should maybe look for other solutions.
Maybe they didn't implement it yet because there's an easy workaround:
create a temporary table including the columns to be skipped, LOAD it,
and then use INSERT..SELECT to copy over only the columns you're
interested in.
Regards,
Harrison
--
Harrison C. Fisk, Trainer and Consultant
MySQL AB, www.mysql.com
Get a jumpstart on MySQL Cluster --
http://www.mysql.com/consulting/packaged/cluster.html
Regards,
Harrison
--
Harrison C. Fisk, Trainer and Consultant
MySQL AB, www.mysql.com
Mobile: +1 315 380-6048
Get a jumpstart on MySQL Cluster --
http://www.mysql.com/consulting/packaged/cluster.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
