I need to load data from a log file. The file is a space seperated file. I can
already ignore the first 7 lines (that are commnet lines), but what I can not seem to
do is:
1. get load data to use the space seperated format.
2. only load certain columns.
I tried: mysql> LOAD DATA INFILE 'persondata.txt'
-> INTO TABLE persondata (col1,col2,...);
But it gives me an error about field lists. I can not find anything about defining
field lists in the manual.
Thanks for your time
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
