List:MySQL on Win32« Previous MessageNext Message »
From:Daniel da Veiga Date:February 14 2005 3:03am
Subject:Re: Importing a separated file into mysql, national charset problem??
View as plain text  
You can use mysqlimport (/bin/mysqlimport) and using the syntax (check
the manual) put some FIELDS_ENCLOSED_BY, FIELDS_TERMINATED_BY stuff
(remember to set it to "" if they do not exists, else, default is
used) and I believe you'll get it done right. At least I imported a
bunch of values using odd separators (and floats among them) with
this.

Hope that helps,

-- 
Daniel da Veiga
Computer Operator - RS - Brazil
Thread