Hello I have a fixed width csv file. To import it I use the following statement -
load data local infile 'F:/Documents and Settings/Insane/Desktop/test.csv' into table `insane`.`user_details_copy` fields escaped by '\\' enclosed by '' terminated by '' lines terminated by \n' IGNORE 1 LINES ( id, user_name, user_email, user_ref_from, other_ref, want_notify, dateofdown ) Now the problem is what even value I give for IGNORE LINES, MySQL seems to import from the first line always ? Whereas if the CSV file is , delimited, the IGNORE LINES syntax seems to be working fine ? Is IGNORE LINES not valid for FIXED LENGTH format or I am missing something ? Thanks in advance karam __________________________________________________ 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
