I can't upload this data correctly. I have tried everythink I know to get it to upload
correctly and it won't do it. Can someone
offer some assistance?
Data:
101934819255830115793 Keyword crayola magic wardrobe
101934819309230988241 Keyword hanukah
101934819339740430408 Keyword viva 28.8
101934819365813570255 Keyword crayola magic wardrobe
101934819368932068157 Keyword crayola magic wardrobe
101934819436633829851 Keyword dumdumboys
Table:
CREATE TABLE uplVisitParams (
Version char(3) DEFAULT '' NOT NULL,
VisitLogID char(20) DEFAULT '' NOT NULL,
ParamName char(20) DEFAULT '' NOT NULL,
ParamValue char(50) DEFAULT '' NOT NULL
);
Upload Sql:
LOAD DATA INFILE 'testfile' IGNORE INTO TABLE uplVisitParams FIELDS TERMINATED BY '' LINES
TERMINATED BY '\r\n';
Result:
+---------+--------------------+-----------+----------------------------------------------------+
| Version | VisitLogID | ParamName | ParamValue
|
+---------+--------------------+-----------+----------------------------------------------------+
| 101 | 934819255830115793 | Keyword | crayola magic wardrobe
101934819309230988241 Keyw |
+---------+--------------------+-----------+----------------------------------------------------+
Brandon Shuey
WebCentric Inc.
(316) 686-4811
brandon@stripped