ginal Message -
From: "Scott Hamm" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "Mysql"
Sent: Tuesday, April 05, 2005 1:02 PM
Subject: Re: Duplicated records
> Well, to be more specific, I would like to list *ALL* duplicated Batch
> rath
Scott,
To find dupe batch values
SELECT batch, COUNT(batch) AS Cnt
FROM qa
GROUP BY batch
HAVING Cnt > 1;
Peter Brawley
http://www.artfulsoftware.com
-
Scott Hamm wrote:
Sorry for the confusion. I don't mean a duplicated records, but to
find duplicated Batch where two d
ries together into a single big query. Are you running V4.1 or
> later? If you are, I could take a stab at the combined query
>
> Rhino
>
>
> - Original Message -
> From: "Scott Hamm" <[EMAIL PROTECTED]>
> To: "Rhino" <[EMAIL PROTEC
t;Rhino" <[EMAIL PROTECTED]>
Cc: "Mysql"
Sent: Tuesday, April 05, 2005 11:14 AM
Subject: Re: Duplicated records
> Sorry for the confusion. I don't mean a duplicated records, but to
> find duplicated Batch where two different operators worked on a single
> b
Sorry for the confusion. I don't mean a duplicated records, but to
find duplicated Batch where two different operators worked on a single
batch (one started off, then another one to finish the batch) and a
single reviewer to review a batch. I need a list that lists duplicated
Batches
- Original Message -
From: "Scott Hamm" <[EMAIL PROTECTED]>
To: "Mysql"
Sent: Tuesday, April 05, 2005 10:05 AM
Subject: Duplicated records
> Here is my novice question:
> I need to find duplicates in "Batch" category when I issued this query:
Hi Scott,
Here is my novice question:
I need to find duplicates in "Batch" category when I issued this query:
SELECT * FROM QA WHERE Batch=439584414;
Result:
90577
1 26615334JulieAnt25 5 5 439584414
2004-10-03 00:00:00 2004-10-03
00:00:000
Here is my novice question:
I need to find duplicates in "Batch" category when I issued this query:
SELECT * FROM QA WHERE Batch=439584414;
Result:
90577
1 26615334JulieAnt25 5 5 439584414
2004-10-03 00:00:00 2004-10-03
00:00:000 905
On 10 Apr 2002, at 12:16, Jeffrey Flowers wrote:
> Perhaps having a column in my
> database with a serialized, unique record number would be a way to prevent
> this in the future?
That would allow you to delete just one of the duplicates (which you
also do with LIMIT 1 on your DELETE query), bu
>You are 100% correct.
>
>Since MySQL does not support "cursors", I always
>put an auto_increment column in my tables for just
>this purpose.
>
>(This is what other DBMS' do, they just do it behind
>your back)
You're right. I use DBase IV at work and every record has an internal record
number.
>
Sent: Wednesday, April 10, 2002 11:16 AM
To: [EMAIL PROTECTED]
Subject: Deleting Duplicated Records
I am new to MySQL and I have a test database that I am playing with. Through
an accident while playing around, I ended up with two identicle records in
the database. I did a filter to try and ch
I am new to MySQL and I have a test database that I am playing with. Through
an accident while playing around, I ended up with two identicle records in
the database. I did a filter to try and change just one of them but both
would come up, so I couldn't see how I was supposed to delete just one of
12 matches
Mail list logo