List:General Discussion« Previous MessageNext Message »
From:spikerlion Date:November 10 2011 8:44am
Subject:LOAD DATA INFILE Problem
View as plain text  
Hello,

after switching from MySQL 5.0.67 to 5.1.59 we get the following problem:

We want to import data from a textfile 
example of the textfile:
test@stripped$yes$432145$xyz

The command is: LOAD DATA LOCAL INFILE 'textfile.txt' INTO TABLE TESTTABLE FIELDS
TERMINATED BY '$';

Selecting the data from the TESTTABLE by "select * from TESTTABLE;" the data in the first
field looks like "|test.com", if I do a "select * from TESTTABLE\G" I can see
"test@stripped" in the first field.

Are there any changes between MySQL 5.0 and 5.1 ?


Best Regards
Spiker
-- 
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
Thread
LOAD DATA INFILE Problemspikerlion10 Nov