On Wednesday, March 20, 2002, at 10:40 PM, Jimi Oleksiak wrote:
> Why doesn't mysql read the whole file? and how can I find the "Warnings: > 1"? > > Think I can help with the first - depending how your text file was generated it may use carriage return (ASCII 13) or line feeds (10) at the end of each line. Macs (System 9) traditionally use one, and Unix (MacOS X) the other - sorry can't remember which way round! So I use a command like (for .csv file): LOAD DATA LOCAL INFILE 'xxx.csv' INTO TABLE xxx FIELDS TERMINATED BY ',' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\r' Changing the end to TERMINATED BY '\n' cures the problem - or vice versa, if you see what I mean. Hope that rather poor explanation helps! Rupert --------------------------------------------------------------------- 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
