Hello Ppl... I have a fixed length CSV file and when I try to import it using the LOAD LOCAL command
load data local infile 'F:/Documents and Settings/Karam/Desktop/test.csv' into table `karam`.`test_table` fields escaped by '\\' enclosed by '' terminated by '' lines terminated by '\n' ignore 5 lines ( ID, VARCH_VAL, RAW_VAL, LONG_VAL ) MySQL always seem to import from the first line itself and never ignores those 5 lines which is expected ? But when I import it from a tab separated file, LOAD LOCAL works fine and it ignores the 'n' lines which is specified in the query ? Am I missing something or MySQL does not ignores lines for a FIXED LENGTH CSV ? Thanks in advance. Karam SQL, QUERY __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- 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
