On 26-Oct-2003 Heinrich Stoellinger wrote:
> I have a small dBase4 Database that contains 260 records. Exporting it
> to a text file and then using LOAD DATA into table... I see that of the
> 260 records only 204 get loaded. I cannot make out what is specific
> about the records skipped. I do get warnings but (since I am using only
> 4.1.0 alpha!) show warnings doesn't help at all. What is the typical
> reason for LOAD DATA to skip records?
Usually embedded quotes, linefeeds or other terminating characters in
strings.
Try SELECT ... INTO OUTFILE ...
Sort the origin input & output files for clues as to what is missing & why.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
