I cant tell you how much i love you right now :)
This works flawless!! Thanks a million times!
From: Harrison Fisk <[EMAIL PROTECTED]>
To: "Jessica Svensson" <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: LOAD DATA and skip columns in text file...
Date: Wed
can use STR_TO_DATE to "fix" a
datetime field before it is loaded into the table directly.
will be quite hard to figure out on my own i guess?
Thanks again!
From: Harrison Fisk <[EMAIL PROTECTED]>
To: "Jessica Svensson" <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Sub
o: "Jessica Svensson" <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: LOAD DATA and skip columns in text file...
Date: Wed, 25 May 2005 19:03:20 -0400
Hi,
On May 25, 2005, at 1:28 PM, Jessica Svensson wrote:
That just complicates things alot since i get around 200 files, 6 ti
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
t: Wednesday, May 25, 2005 12:28 PM
To: mysql@lists.mysql.com
Subject: Re: LOAD DATA and skip columns in text file...
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 lo
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:5
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
>
