On Fri, 20 Aug 1999, Brandon Shuey wrote:
> >%_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';
you need a field termination char. looking at your sample data it is either a tab or space
also you would want to check the need for a carage return in your line terminator.
>
> Result:
>
> +---------+--------------------+-----------+----------------------------------------------------+
> | Version | VisitLogID | ParamName | ParamValue
> |
>
> +---------+--------------------+-----------+----------------------------------------------------+
> | 101 | 934819255830115793 | Keyword | crayola magic wardrobe
> 101934819309230988241 Keyw |
>
> +---------+--------------------+-----------+----------------------------------------------------+
> Brandon Shuey
> WebCentric Inc.
> (316) 686-4811
> brandon@stripped
>
>
>
