List:General Discussion« Previous MessageNext Message »
From:Dexter Coelho Date:October 11 2001 3:27am
Subject:Load Infile import puts ' " ' in front of each field?
View as plain text  
Hi folks,

I did a load infile statement of data that was comma delimited and fields 
enclosed in quotes.

Question ? As a result all my field values in the table start with
quotes '"', that is one set of double quotes.

the text file used was exported from Nt from Win SQL server.

It looked fine with its syntax.

Any ideas?

Thanks to the MySQL gang


Get your FREE download of MSN Explorer at

Load Infile import puts ' " ' in front of each field?Dexter Coelho11 Oct