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.
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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Lättare att hitta drömresan med MSN Resor http://www.msn.se/resor/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
