- Original Message -
From: Lucky Wijaya luckyx_cool_...@yahoo.com
To: mysql@lists.mysql.com
Sent: Thursday, 4 April, 2013 10:51:50 AM
Subject: Re: Join query returning duplicate entries
Hi, sorry i tried to help but i hardly understand the use of join in
your query since
duplicate entries
Hi list,
i wrote the following query and it is returning duplicate entries
as shown below, can any one suggest me how to avoid this duplicate entries,
with out using distinct.
Query:
select p.date,p.coacode,p.type,p.crdr,p.quantity,p.amount from
ac_financialpostings p
Hello Trimurthy,
On 4/4/2013 3:21 AM, Trimurthy wrote:
Hi list,
i wrote the following query and it is returning duplicate entries
as shown below, can any one suggest me how to avoid this duplicate entries,
with out using distinct.
Query:
select p.date,p.coacode,p.type,p.crdr
-Original Message-
From: Gary Aitken [mailto:my...@dreamchaser.org]
Sent: Thursday, June 14, 2012 2:58 PM
I can get the table loaded by specifying REPLACE INTO TABLE, but that
still
leaves me with not knowing where the duplicate records are.
To find duplicate entries
select
Is the CREATE TABLE you show the result of SHOW CREATE TABLE or your own
create statement? If the latter, please show the output of SHOW CREATE.
Does SELECT succeed if you remove the INSERT part of the statement?
You might want to consider adding an index on transactionlogid, this
could bring
I have the following table:
CREATE TABLE `graph` (
`tableid1` varchar(20) NOT NULL,
`tupleid1` int(11) NOT NULL,
`tableid2` varchar(20) NOT NULL,
`tupleid2` int(11) NOT NULL,
`node1` int(11) NOT NULL,
`node2` int(11) NOT NULL,
`weight` int(10) NOT NULL,
PRIMARY KEY
| |
+---++--+-+-+---+
ACCOUNTPAYMENTACTION shares the primary key with ACCOUNTACTION
I need to remove duplicate entries that occured at a specific time in
ACCOUNTACTION I then plan to remove the rows in ACCOUNTPAYMENTACTION
that are no longer referenced in ACCOUNTACTION by using an outer join
I
);
Thanks for the pointers ;-)
-Original Message-
From: Magnus Smith [mailto:[EMAIL PROTECTED]
Sent: 07 August 2008 10:35
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Subject: RE: removing duplicate entries
Yes I can see you are correct. I tried setting up a little test case
myself
- thanks
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: 06 August 2008 13:51
To: Magnus Smith
Cc: mysql@lists.mysql.com
Subject: Re: removing duplicate entries
I just did a test case here
select * from amc_25;
+--+
| id |
+--+
|2
On Thu, Aug 7, 2008 at 2:34 AM, Magnus Smith
[EMAIL PROTECTED] wrote:
Yes I can see you are correct. I tried setting up a little test case
myself.
CREATE TABLE ACCOUNTACTION (
ID INT NOT NULL PRIMARY KEY,
ACTIONDATE DATETIME,
ACCOUNT_ID INT NOT NULL
);
Subject: RE: removing duplicate entries
Yes I can see you are correct. I tried setting up a little test case
myself.
CREATE TABLE ACCOUNTACTION (
ID INT NOT NULL PRIMARY KEY,
ACTIONDATE DATETIME,
ACCOUNT_ID INT NOT NULL
);
CREATE TABLE ACCOUNTPAYMENTACTION
| bigint(20) | NO | PRI | | |
| AMOUNTINPENCE | bigint(20) | YES | | NULL| |
+---++--+-+-+---+
ACCOUNTPAYMENTACTION shares the primary key with ACCOUNTACTION
I need to remove duplicate entries that occured at a specific time
| |
+---++--+-+-+---+
ACCOUNTPAYMENTACTION shares the primary key with ACCOUNTACTION
I need to remove duplicate entries that occured at a specific time in
ACCOUNTACTION I then plan to remove the rows in ACCOUNTPAYMENTACTION
that are no longer referenced in ACCOUNTACTION by using an outer join
I can select
Smith
Cc: mysql@lists.mysql.com
Subject: Re: removing duplicate entries
I doubt the belwo sql will give you duplcates
select ACCOUNTACTION.ID http://accountaction.id/ from ACCOUNTACTION
where ACCOUNTACTION.ACTIONDATE like '2008-08-01 02:00%'
group by ACCOUNTACTION.ACCOUNT_ID
having (count
: removing duplicate entries
I doubt the belwo sql will give you duplcates
select ACCOUNTACTION.ID http://accountaction.id/ from ACCOUNTACTION
where ACCOUNTACTION.ACTIONDATE like '2008-08-01 02:00%'
group by ACCOUNTACTION.ACCOUNT_ID
having (count(ACCOUNTACTION.ACCOUNT_ID) 1
SELECT foobar,
COUNT(foobar) AS NumOfFoos
FROM bar
GROUP BY foobar
HAVING ( COUNT(foobar) 1 )
On 2/6/07, Tomás Abad Fernández [EMAIL PROTECTED] wrote:
Any can tell me a slq to find duplicate entries in a table?
Thanks,
Tomás
--
Lars Schwarz
Gottorpstrasse 20
26122 Oldenburg
T 0441
That actually should be
HAVING ( NumOfFoos 1 )
- Original Message -
From: Lars Schwarz [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, February 06, 2007 11:26 AM
Subject: Re: How find duplicate entries
SELECT foobar,
COUNT(foobar) AS NumOfFoos
FROM bar
GROUP BY foobar
: How find duplicate entries
Any can tell me a slq to find duplicate entries in a table?
Thanks,
Tomás
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.411 / Virus Database
Hi all,
I have a table like this
TABLE
--
tagid
taggerid
objectid
There is a primary key on (tagid, taggerid, objectid).
First I remove that key, then I am changing the object id (because
I've changed my objects), but what happens now is that I suddenly have
duplicate (tagid, taggerid,
Peter Van Dijck wrote:
Hi all,
I have a table like this
TABLE
--
tagid
taggerid
objectid
There is a primary key on (tagid, taggerid, objectid).
First I remove that key, then I am changing the object id (because
I've changed my objects), but what happens now is that I suddenly have
-23
23:49:42-2005-03-09 00:00:00-TD4-TD
289267-210201021-XOR-3--00-00 00:00:00-2005-03-09 00:00:00-2006-05-26
13:37:27-2005-03-09 00:00:00-TD4-TD
there are a lot of duplicate entries there...
What i need to do is to find out the entries that have the same
cli,type,status (the rest are not so
-TD4-TD
there are a lot of duplicate entries there...
What i need to do is to find out the entries that have the same
cli,type,status (the rest are not so important) and delete all BUT ONE! I
have no clue as to how i can delete all but one... Also the rest of the
data
may differ a little bit
mysql select count(*) - count(distinct username,email) as 'duplicate
names' from users;
+-+
| duplicate names |
+-+
| 2 |
+-+
1 row in set (0.00 sec)
I got this select syntax to count how many duplicate entries i have.
But i dont know
syntax to count how many duplicate entries i have.
But i dont know how to show the duplicate entries i have on that
table.
SELECT username, email, COUNT(*) as n
FROM users
GROUP BY username, email
HAVING n 1
Pls help!
--
Louie Miranda
http://www.axishift.com
--
Tom Crimmins
Interface
Try this
Take dump of table using mysqldump utility
eg : mysqldump db name
tablename --quick --allow-keywords --no-create-info dumpfilename
Then
truncate table data
eg: mysqltruncate table tablename;
create primary or unique keys what ever you want on table
Then restore the data from dump
Suresh [EMAIL PROTECTED] wrote:
I am porting from 4.0.0-alpha-nt to 4.0.1-alpha-nt. In which i have a
table with two primary key, my older mysql server insert all the records
except the duplicate fields(Primary Key). Whereas in the new mysql
server it exits whenever it sees a duplicate
.
Eldo.
On Tue, 21 Sep 2004 19:32:17 -0400, Rhino [EMAIL PROTECTED] wrote:
- Original Message -
From: Suresh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 6:43 PM
Subject: Duplicate Entries
Hello All,
I am porting from 4.0.0-alpha-nt to 4.0.1
Suresh wrote:
Hi,
Yes ofcourse it is a primary key with two fields. The insert exists whenever it
has a duplicate entry, it doesn't continue with further records. Is there any
scope to resolve it.
Thanks
Suresh
Eldo Skaria wrote:
insert ignore
--
MySQL General Mailing List
For list archives:
Hello All,
I am porting from 4.0.0-alpha-nt to 4.0.1-alpha-nt. In which i have a
table with two primary key, my older mysql server insert all the records
except the duplicate fields(Primary Key). Whereas in the new mysql
server it exits whenever it sees a duplicate entry. How to resolve it ?
- Original Message -
From: Suresh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 6:43 PM
Subject: Duplicate Entries
Hello All,
I am porting from 4.0.0-alpha-nt to 4.0.1-alpha-nt. In which i have a
table with two primary key, my older mysql server insert
Hi,
Suresh may be expressing that he has a primary key with two fields.
Eldo.
On Tue, 21 Sep 2004 19:32:17 -0400, Rhino [EMAIL PROTECTED] wrote:
- Original Message -
From: Suresh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 6:43 PM
Subject: Duplicate
-
From: Axel IS Main [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 21, 2004 10:25 PM
To: [EMAIL PROTECTED]
Subject: Preventing Duplicate Entries
I have a php app that updates an ever growing table with new information
on a regular basis. Very often the information is duplicated. I'm
currently
I have a php app that updates an ever growing table with new information
on a regular basis. Very often the information is duplicated. I'm
currently handling this by checking the table for duplicate values every
time I go to add new data. As you can imagine, as the table grows it
takes longer
On Sun, Mar 21, 2004 at 07:24:48PM -0800, Axel IS Main wrote:
I have a php app that updates an ever growing table with new
information on a regular basis. Very often the information is
duplicated. I'm currently handling this by checking the table for
duplicate values every time I go to add new
Axel IS Main wrote:
I have a php app that updates an ever growing table with new information
on a regular basis. Very often the information is duplicated. I'm
currently handling this by checking the table for duplicate values every
time I go to add new data. As you can imagine, as the table
Hi all,
How do i do this ?
i have a table with one of the column named uid,
Now i want to insert a new row,only if no other
row exist with the uid i m trying to insert.
I hope its clear.
thanks for any reply .
harsh
On Sun, 20 Jul 2003, harsh wrote:
Hi all,
How do i do this ?
i have a table with one of the column named uid,
Now i want to insert a new row,only if no other
row exist with the uid i m trying to insert.
I hope its clear.
Hello Harsh,
How about making the uid column in your table a
/CREATE_TABLE.html and
http://www.mysql.com/doc/en/ALTER_TABLE.html for information about keys.
-Brian McCain
- Original Message -
From: Wileynet [EMAIL PROTECTED]
To: 'mysql users' [EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 3:03 PM
Subject: Beginner question - Preventing Duplicate Entries
Is there a sql statement that would not allow the same entry twice.
Something like INSERT into myTable s WHERE s != Value(?). I dont know
if that makes sense but I thought I would give it a shot.
Basically I want to know if it is possible and if so can you point me to
a webpage or give me an
deadlocks.
~Wynne
-Original Message-
From: Wileynet [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 2:04 PM
To: 'mysql users'
Subject: Beginner question - Preventing Duplicate Entries
Is there a sql statement that would not allow the same entry twice.
Something like INSERT
. This of course would require transactions supported
by InnoDB tables and not supported by MyISAM.
~Wynne
-Original Message-
From: Wileynet [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 2:04 PM
To: 'mysql users'
Subject: Beginner question - Preventing Duplicate Entries
Sorry, but justs a quick remark on the top:
Have you looked at small and KAPITAL letters?
--
Franz Alt
[EMAIL PROTECTED]
at work I run mysql 3.23.45. on a windows2000 machine with apache 1.3.23
and php4.06. at home it's Linux SuSe *.0, mysql 4.03 apache 1.3.26 and
php4.2.3. the problem is
at work I run mysql 3.23.45. on a windows2000 machine with apache 1.3.23
and php4.06. at home it's Linux SuSe *.0, mysql 4.03 apache 1.3.26 and
php4.2.3. the problem is I'm having problems inserting data into
temporary tables. the results are different running the same script.
here is the script
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi everyone,
I'm having some weirdness when inserting from the php api, I do not get
the same results if I use the mysql server directly. Here is the code:
$qry=INSERT INTO news VALUES(NULL, NULL, \a value\, \b value\);
mysql_connect(localhost,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Nick Wilson declared
I'm having some weirdness when inserting from the php api, I do not get
the same results if I use the mysql server directly. Here is the code:
Please disregard. It appears to be some bizzare Apache/http thing,
: Thursday, June 13, 2002 4:57 PM
Subject: Re: duplicate entries mystery
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Nick Wilson declared
I'm having some weirdness when inserting from the php api, I do not get
the same results if I use the mysql server directly. Here
to be
checked individually, and how busy you expect the system to be overall.
Andrew Hazen
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 8:17 PM
To: [EMAIL PROTECTED]
Subject: RE: data compare and duplicate entries..
IMHO it is an expensive
hi,
I was looking for an SQL statement or script that whould allow me to compare
data when it was entered into a mysql-php field on a web page so that it
checks whether the data entered has not been used before in the database..
In short, when data needs to be entered, the statement/script must
form
Andrew Hazen
-Original Message-
From: Tech @NorthWeb [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 9:32 AM
To: mysql
Subject: Fw: data compare and duplicate entries..
hi,
I was looking for an SQL statement or script that whould allow me to
compare
data when it was entered
Are you writing a php script, perhaps with a form and a submit button,
that connects to mysql?
-Steve.
-Original Message-
From: Tech @NorthWeb [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 9:32 AM
To: mysql
Subject: Fw: data compare and duplicate entries..
hi,
I was looking
On Thu, 2 May 2002 15:31:44 +0200
Tech @NorthWeb [EMAIL PROTECTED] wrote:
hi,
I was looking for an SQL statement or script that whould allow me to compare
data when it was entered into a mysql-php field on a web page so that it
checks whether the data entered has not been used before in the
Hello,
I was wondering how would it be possible to delete those records from
database which has just same data? There can be also up to ten copies of the
record in database, and all but one should be deleted. Do you have any easy
way to do this?
Thank you,
Ville Mattila
duplicate entries
Hello,
I was wondering how would it be possible to delete those records from
database which has just same data? There can be also up to ten copies of the
record in database, and all but one should be deleted. Do you have any easy
way to do this?
Thank you,
Ville Mattila
* Ville Mattila
I was wondering how would it be possible to delete those records from
database which has just same data? There can be also up to ten
copies of the record in database, and all but one should be deleted.
Do you have any easy way to do this?
You could do it by creating a new
hi,
i've got a table collecting info from html forms. problem is, certain
wiseguys always make multiple entries. could someone clue me in to how
i can select the Last entry where there is a duplicate for the User
(type text, these are email addresses), and automatically delete any
previous
Tom Churm ([EMAIL PROTECTED]) writes:
hi,
i've got a table collecting info from html forms. problem is, certain
wiseguys always make multiple entries. could someone clue me in to how
i can select the Last entry where there is a duplicate for the User
(type text, these are email
I hope that someone here can help me with a little problem. We have a
database that has a lot of duplicate entries in it for one of the fields
(email). I need to find a way to search the database, find all of the
duplicate entries and delete all but one of the entries. It would
I want to prevent duplicate entries into my mysql database which holds
invertory of all network eqpt at my site. Engineers access it thru
netscape and the query insert is done via pdp [below].
I will place the script into php, any pointers on this would be
appreciated.
THX!
Pete
html
-- Original Message --
From: Pete Kuczynski [EMAIL PROTECTED]
Date: Tue, 26 Jun 2001 13:19:02 -0500
I want to prevent duplicate entries into my mysql database which holds
invertory of all network eqpt at my site. Engineers access it thru
netscape
My primary key field is a auto incremented index, the field I want to
make unique, or to say, prevent duplicates in, is the hostname field,
which has, hostnames of devices. Is the key word UNIQUE then?
Not all of the devices have hostnames assigned to them, like terminals,
so the hostname field
-- Original Message --
From: Pete Kuczynski [EMAIL PROTECTED]
Date: Tue, 26 Jun 2001 14:02:08 -0500
My primary key field is a auto incremented index, the field I want to
make unique, or to say, prevent duplicates in, is the hostname field,
which has,
We recently moved our hardware inventory database off of access (yay!)
over to mysql. During it's days as an access database it aquired a
numbered of duplicate entries. In every case (or at least the ones I'm
working on) the serial numbers will be the same but likely all other info
in the mythical v4!) you'll
have to process that list in something like Java or PHP.
HTH,
Cal
http://www.calevans.com
-Original Message-
From: Josh Burroughs [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 6:48 PM
To: [EMAIL PROTECTED]
Subject: hunting down duplicate entries
We recently
On Wed, Mar 14, 2001 at 03:48:28PM -0900, Josh Burroughs wrote:
We recently moved our hardware inventory database off of access (yay!)
over to mysql. During it's days as an access database it aquired a
numbered of duplicate entries. In every case (or at least the ones I'm
working
64 matches
Mail list logo