Re: Load Data only loads 1 record

2002-03-21 Thread rupert cutler
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 e

Load Data only loads 1 record

2002-03-20 Thread Jimi Oleksiak
Dear mysql people: I am trying set up a dataset in mysql version 3.23.42 on a Mac OS X Server v10.2. When I use the "load data" statement, only one record gets read into the table. If I edit the file and remove the top record, then when I give another "load data" command, mysql reads the n