Hi Patrick,
I was doing that it was taking 20 seconds to chop the fields from the file.
That was the problem.
Meanwhile about my problem I have seen that the lines in data files end with
"\r\n" not "\n" so it solved the problem.
Now it takes 3 seconds to dump the file and chop the necassary fields.
thanks to MySQL.
:)
thank yo again for answer...
----- Original Message -----
From: "Patrick Connolly" <[EMAIL PROTECTED]>
To: "Ferhat BINGOL" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Sunday, November 21, 2004 10:00 AM
Subject: Re: LOAD DATA INFILE question...
> Somewhere about Sat, 20-Nov-2004 at 06:27PM +0100 (give or take), Ferhat
BINGOL wrote:
>
> |> Hi,
> |>
>
> |> I have a 72 fields data txt file and I was inserting all data
> |> previously but now I need only some of them to dump into the table.
>
> |> I would like to select only 4 fields which are the 1st, 5th,28th
> |> and 71st fields.
>
> |> Is there a statement to do that.
> |>
>
> I think it would be simpler to pre-process the file using cut with the
> appropriate delmiter if it's not tab-delimited already. Then import
> the reduced file.
>
> HTH
>
> --
> ___ Patrick Connolly
> {~._.~}
> _( Y )_ Good judgment comes from experience
> (:_~*~_:) Experience comes from bad judgment
> (_)-(_)
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
