How to remove the duplicate values in my table!

Hi, I found the bug in my servlet ,when I run my application it enter one record to the database without duplicate values.Now I want to clean my table by removing all duplicate rows .Any thoughts?

Re: Finding not quite duplicates

3) If there is a match in `b` against `a`, but the ONLY match is a row where `a`.`prod_discont` = `1`, return discontinued. So the query that would accomplish that would be: SELECT IF(a.prod_num IS NOT NULL,IF(a.prod_discont = 0,a.prod_num,discontinued),) as prod_num FROM b LEFT JOIN

Re: Using Replication in mySQL version 5

Date: Mon, 17 Nov 2008 10:16:16 + From: Tompkins Neil [EMAIL PROTECTED] Subject: Using Replication in mySQL version 5 We are looking to upgrade our version of mySQL to the latest version of mySQL 5. One of the main features we are going to think about using is replication for our website

Re: Finding not quite duplicates

Ok, I think I understand If there is a product that matches and is not discontinued it should only return that one. I think I just learned about this trick from the mysql manual, although I can't seem to remember what section I found it in. Basically you can join the table again, with the

RE: Using Replication in mySQL version 5

You'll want an alert to page you when the replication slaves stop for an error; look for Matthew Montgomery's script; we added paging and an 'autofix' step to correct a limited number of duplicate key errors (and email when it does so); I page for other errors. We've had M-M 5.0 replication and

Re: Using Replication in mySQL version 5

You will probably want to set read_only = 1 in the my.cnf on the slave so only super users can change tables. If you do partial replication, you must be sure your developers do not cross-reference schemas where one is replicated and the other is not. You will either get a replication error

MySQL University session on November 20: Using memcached in MySQL deployments

This Thursday (November 20, 2008), Martin MC Brown will explain how to use memcached in MySQL deployments. MC is the author of the memcached section of the MySQL Reference Manual, and does all other memcached documentation in the Sun Database Group, too. The session will start at 14:00 UTC / 8am

Virtualizing MySQL

I am looking into the idea of setting up 10 - 15 virtualized instances of MySQL. The reason for this is as follows...we are going to be setting up a 3 to 4 node MySQL replication cluster (1 master-rw and 2 slaves-ro)...each having 16 to 32 GB of RAM. In order for our development team to do

RE: Finding not quite duplicates

-Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2008 3:33 AM To: mysql@lists.mysql.com Subject: Re: Finding not quite duplicates [JS] If there were one row that had prod_discont = 1, and another that had prod_discont = 0, and they both

Re: Virtualizing MySQL

[EMAIL PROTECTED] (Shain Miley) writes: I am looking into the idea of setting up 10 - 15 virtualized instances of MySQL. The reason for this is as follows...we are going to be setting up a 3 to 4 node MySQL replication cluster (1 master-rw and 2 slaves-ro)...each having 16 to 32 GB of RAM.

Re: How to remove the duplicate values in my table!

On Nov 19, 2008, at 3:24 AM, jean claude babin wrote: Hi, I found the bug in my servlet ,when I run my application it enter one record to the database without duplicate values.Now I want to clean my table by removing all duplicate rows .Any thoughts? I assume you have a unique record

MBRWithin bug?

I'm trying to use the geospatial extensions for the first time. The basic idea is to track points and see if they fall within rectangles, so the core work that the database is doing is a query that involves MBRWithin. It mostly works, but sometimes it doesn't when I think it should. Here's

Re: Overhead Issue

If you are frequently deleting many records, then that can cause fragmentation. But if you are deleting that many records, you usually are deleting old records. To work around this overhead, I usually use MERGE tables. On a periodic basis you create a new table, add it to the MERGE list

RE: MBRWithin bug?

The function is working correctly. Check your coordinates. The point doesn't fall within the polygon you defined. ..Tom -Original Message- From: Chris Kantarjiev [mailto:[EMAIL PROTECTED] Sent: Wed 19-Nov-08 19:38 To: mysql@lists.mysql.com Subject: MBRWithin bug? I'm trying to

RE: MBRWithin bug?

Tom, Thanks for the response - as I said, I might be being an idiot. I really don't see where the problem is! (37.4324379 -122.152) (37.428 -121.1575 37.428 -121.1485 37.437 -121.1485 37.437 -121.1575 37.428 -121.1575) -122.1529 is between -121.148 and -121.1575 37.4324 is