On Tue, Jul 17, 2001 at 03:34:01PM -0500, John Hunter wrote:
> > "Paul" == Paul DuBois <[EMAIL PROTECTED]> writes:
>
>
> Paul> ALTER IGNORE this_table ADD PRIMARY KEY (name,time)
>
> They are not null so this works well with a slight modification:
>
> ALTER IGNORE TABLE this_table ADD
> "Paul" == Paul DuBois <[EMAIL PROTECTED]> writes:
Paul> ALTER IGNORE this_table ADD PRIMARY KEY (name,time)
They are not null so this works well with a slight modification:
ALTER IGNORE TABLE this_table ADD PRIMARY KEY (name,time)
^
One further question. Will this au
At 2:42 PM -0500 7/17/01, John Hunter wrote:
>I have a table in which I want to eliminate duplicates, where I define
>a duplicate to be any two rows with the same values on field1 and
>field2
>
>This gives me the sort I want
>SELECT * FROM this_table ORDER BY name, time;
>
>But in addition I would
So sprach »John Hunter« am 2001-07-17 um 14:42:13 -0500 :
>
> I have a table in which I want to eliminate duplicates, where I define
> a duplicate to be any two rows with the same values on field1 and
> field2
>
> This gives me the sort I want
> SELECT * FROM this_table ORDER BY name, time;
Unt
I have a table in which I want to eliminate duplicates, where I define
a duplicate to be any two rows with the same values on field1 and
field2
This gives me the sort I want
SELECT * FROM this_table ORDER BY name, time;
But in addition I would like to drop duplicates.
Is there a way to modif
