List:General Discussion« Previous MessageNext Message »
From:Brandon Shuey Date:August 20 1999 4:11pm
Subject:Help!! Simple Upload Problem
View as plain text  
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



Thread
Help!! Simple Upload Problem(Brandon Shuey)20 Aug
  • Re: Help!! Simple Upload Problemsasha20 Aug
  • Re: Help!! Simple Upload ProblemBenjamin David Hildred20 Aug