Thanks so much, that did the trick. I really appreciate the mercy on a poor newbie.
Thanks again, David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 5:28 PM To: David McBride Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: load data help >My question is, how can I take a log file that has 25 columns of data and >tell mysql to only load column 1, column 3, and column 7 from the raw log >file? I'm not sure mysql can do this. I'd be more inclined to use cut on a Linux system in the following fashion: cut -d ' ' -f 1,3,7 <in.dat >out.dat then use out.dat as the file spec for the 'Load Data INFILE' Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]