Jim, > TERMINATED BY ' ' to indicate that the fields are space deliminated > LINES TERMINATED BY '\n' to indicate that each line is terminated by > new line....again I'm thinking here that > I may need to use a '\r' instead.
As a rule of thumb, depending on where your logs come from: a) Windows: \r\n b) Unix: \n c) Mac OS: \r > Question: how do I get mysql to ignore specified fields? Read the manual? ;-) http://www.mysql.com/doc/en/LOAD_DATA.html Well, in this case, this wouldn't help you too much, just make things clear: You can have more columns in the table than fields in the import file (you would just specify which columns you want to fill with data), but not the other way around. My suggestions: a) Put some dummy columns in your table. b) As an alternative, filter out the fields you don't need with some application. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
