RE: load data help

2004-04-01 Thread David McBride
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

RE: load data help

2004-03-31 Thread David McBride
list. Thanks again, David David McBride writes: 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

RE: load data help

2004-03-31 Thread David McBride
. Thanks, David David McBride writes: 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

load data help

2004-03-30 Thread David McBride
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