RE: load data help
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]
Re: load data help
David McBride [EMAIL PROTECTED] writes: Thanks so much, that did the trick. I really appreciate the mercy on a poor newbie. David, You're quite welcome. Now if I could find an employer willing to pay me for utilizing the 23 years of knowledge I used to provide such a solution :) Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: load data help
Thanks for the reply. I was a little confussed on the exact defintion of a line, I thought it meant a whole row of data. The space seperated fields worked great, but still gave me the error: ERROR 1054: Unknown column 'col1' in 'field list' I could not find anywhere on how to define the field 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 columns. I tried: mysql LOAD DATA INFILE 'persondata.txt' - INTO TABLE persondata (col1,col2,...); David, Based upon the manual for 4.0.17 the following syntax would fit your description: LOAD DATA INFILE 'persondata.txt' INTO TABLE persondata FIELDS TERMINATED by ' ' (col1,col2,...); You may need the LOCAL key word if you want the client to read the data file. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: load data help
I fugured out that I needed to put (name of col1, name of col2) instead of (col1, col2). Duhh Sorry 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? Sorry for being so dense. 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: mysql LOAD DATA INFILE 'persondata.txt' - INTO TABLE persondata (col1,col2,...); David, Based upon the manual for 4.0.17 the following syntax would fit your description: LOAD DATA INFILE 'persondata.txt' INTO TABLE persondata FIELDS TERMINATED by ' ' (col1,col2,...); You may need the LOCAL key word if you want the client to read the data file. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: load data help
Thanks for the reply. I was a little confussed on the exact defintion of a line, I thought it meant a whole row of data. The space seperated fields worked great, but still gave me the error: ERROR 1054: Unknown column 'col1' in 'field list' I could not find anywhere on how to define the field list. In my example, col1 was just a place holder for the first column you wish to load data into. This info will come from the mysql command DESC persondata; This will give you a list of the columns which you can then use to specify which data element from the line you want to go into each column from the table. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
load data help
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]
Re: load data help
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: mysql LOAD DATA INFILE 'persondata.txt' - INTO TABLE persondata (col1,col2,...); David, Based upon the manual for 4.0.17 the following syntax would fit your description: LOAD DATA INFILE 'persondata.txt' INTO TABLE persondata FIELDS TERMINATED by ' ' (col1,col2,...); You may need the LOCAL key word if you want the client to read the data file. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]