No just every row needs to be unique. Sorry for the confusion...
From: "Robert Dunlop" <[EMAIL PROTECTED]>
To: "shaun thornburgh"
<[EMAIL PROTECTED]>,
Subject: Re: LOAD DATA INFILE using 4.0.17
Date: Tue, 15 Feb 2005 15:06:19 -0800
So what you meant was every
ploaded file and I dont want these to appear
in my table...
>
>> From: Bastian Balthazar Bux <[EMAIL PROTECTED]>
>> To: shaun thornburgh <[EMAIL PROTECTED]>
>> Subject: Re: LOAD DATA INFILE using 4.0.17
>> Date: Tue, 15 Feb 2005 23:32:56 +0100
>>
>> s
shaun thornburgh <[EMAIL PROTECTED]>
> >Subject: Re: LOAD DATA INFILE using 4.0.17
> >Date: Tue, 15 Feb 2005 23:32:56 +0100
> >
> >shaun thornburgh ha scritto:
> >
> >>Hi,
> >>
> >>I have a table with 26 fields, each row in this table must b
Hi,
Thanks for your reply, but the problem I am facing is that there may be
duplicate values in the uploaded file and I dont want these to appear in my
table...
From: Bastian Balthazar Bux <[EMAIL PROTECTED]>
To: shaun thornburgh <[EMAIL PROTECTED]>
Subject: Re: LOAD DATA INFILE
"shaun thornburgh" <[EMAIL PROTECTED]> wrote on 02/15/2005
04:53:54 PM:
> Hi,
>
> I have a table with 26 fields, each row in this table must be unique. I
> can't define all of the fields to be primary keys as the limit is 16.
> Therefore before I insert data I have to check that each row is un
Hi,
I have a table with 26 fields, each row in this table must be unique. I
can't define all of the fields to be primary keys as the limit is 16.
Therefore before I insert data I have to check that each row is unique. Data
is to be inserted into this table from files uploaded to the server - CSV
