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]
