By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,188 Members | 1,023 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,188 IT Pros & Developers. It's quick & easy.

MySQL Load data infile divides data field in two parts. The later moved to next field

P: 1
By import of a text file with 'load data infile'. The actual field is enclosed by "" an contains two names separated with ',' or a space. Fields in textfile is also separated with ",". Import puts the later part in the next field. Only the first field in lines is affected, one of ten lines is not.
Please help!
Olov
Oct 6 '14 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 1,035
RTFM
Expand|Select|Wrap|Line Numbers
  1. load data infile '/tmp/test06' 
  2. into table test06 
  3. fields terminated by ',' 
  4. optionally enclosed by '"';
  5.  
Oct 6 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.