On Tue, 4 Sep 2001, Curtis Spencer wrote:
> I have a text file with around 25 fields but I only want 5 of them.
> They are not the first 5 fields that I want. Is there a way to skip
> fields using LOAD DATA INFILE so I don't have to build a 25 field table
> and then cut it down?
Read the manual for LOAD DATA INFILE; look at the part where it says
IGNORE. You can tell it to IGNORE the first 5 lines.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php