Software Engineer,
Hewlett Packard
--- rob byrne <[EMAIL PROTECTED]> wrote:
I am trying to load data from a text file into a table using the Load data infile statement. No matter how I change data types I seem only able to load in the first row of data into the MySQL table and no more. I have not been able to trach the source of this error or the cause of it? Does anyone know the cause so I can fix it? RB
check your carrage returns, mysql seems to be unix freindly by default
try adding "lines terminated by '\n'
or "lines terminated by |'\r\n'|
one should fix your problem, it defaults to '\n' but windows uses |'\r\n'|
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
