From: Brandon Shuey
Date: August 20 1999 4:11pm
Subject: Help!!  Simple Upload Problem
List-Archive: http://lists.mysql.com/mysql/10837
Message-Id: <NCBBLICCBKHMEGEDEEMEEEONEIAA.brandon@bottomdollar.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0062_01BEEAFC.D1E33860"

------=_NextPart_000_0062_01BEEAFC.D1E33860
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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



------=_NextPart_000_0062_01BEEAFC.D1E33860--