>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]
