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
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
- Original Message -
From: Scott Hamm [EMAIL PROTECTED]
To: Mysql mysql@lists.mysql.com
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:
SELECT * FROM QA WHERE Batch
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
: 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
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
: 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
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
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 different
[EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: Mysql mysql@lists.mysql.com
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
rather than to count them.
SELECT ID, Batch, KeyDate, OperatorID, QAID, NTID
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
, 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 change just one of them but both
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.
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), but
12 matches
Mail list logo