I am very keen to see a closure to this thread so that I can add to my
snippets.
Let's all know what worked best out of many solutions that have been
proposed.
--Shreyas
On Tue, Jul 20, 2010 at 10:07 AM, Jim Lucas li...@cmsws.com wrote:
Peter wrote:
Hi All,
I have a table which contain's
Use distinct.
SELECT DISTINCT COLUMN1, COLUMN2 FROM ... ...
Shiplu Mokadd.im
My talks, http://talk.cmyweb.net
Follow me, http://twitter.com/shiplu
SUST Programmers, http://groups.google.com/group/p2psust
Innovation distinguishes bet ... ... (ask Steve Jobs the rest)
--
PHP General Mailing
Hi Shiplu,
Thanks for reply.
Distinct function hide the duplicate records while we selecting the
record through the Query
i want to remove the duplicate entries in my table
i need a Delete Query instead of Select Query
shiplu wrote:
Use distinct.
SELECT DISTINCT COLUMN1, COLUMN2
On 19 July 2010 05:44, Peter pet...@egrabber.com wrote:
Hi All,
I have a table which contain's some duplicate rows. I just want to delete
the duplicate records alone
not original records.
Assume my table as look as below
column1 column2
1
a
1
a
2
b
3
c
On 19 July 2010 15:01, Richard Quadling rquadl...@gmail.com wrote:
On 19 July 2010 05:44, Peter pet...@egrabber.com wrote:
Hi All,
I have a table which contain's some duplicate rows. I just want to delete
the duplicate records alone
not original records.
Assume my table as look as below
How about this :
CREATE TEMPORARY TABLE bad_temp1 (id INT,name VARCHAR(20));
INSERT INTO bad_temp1 (id,name) SELECT DISTINCT id,name FROM SAMPLE;
Regards,
Shreyas
On Mon, Jul 19, 2010 at 7:31 PM, Richard Quadling rquadl...@gmail.comwrote:
On 19 July 2010 05:44, Peter pet...@egrabber.com
Just to add more perspective :
You will have a table with DISTINCT values.
Drop the initial table (better take a back-up); copy from the temporary
table which will have only DISTINCT values.
Regards,
Shreyas
On Mon, Jul 19, 2010 at 7:58 PM, Shreyas Agasthya shreya...@gmail.comwrote:
How
Peter wrote:
Hi All,
I have a table which contain's some duplicate rows. I just want to
delete the duplicate records alone
not original records.
Assume my table as look as below
column1 column2
1
a
1
a
2
b
3
c
3
c
i want the above table need to be as below, After
Hi All,
I have a table which contain's some duplicate rows. I just want to
delete the duplicate records alone
not original records.
Assume my table as look as below
column1 column2
1
a
1
a
2
b
3
c
3
c
i want the above table need to be as below,
On Mon, Jul 19, 2010 at 10:14:30AM +0530, Peter wrote:
Hi All,
I have a table which contain's some duplicate rows. I just want to
delete the duplicate records alone
not original records.
Assume my table as look as below
column1 column2
1
a
1
a
2
b
3
c
3
On Mon, Jul 19, 2010 at 10:44 AM, Peter pet...@egrabber.com wrote:
Hi All,
I have a table which contain's some duplicate rows. I just want to delete
the duplicate records alone
not original records.
Assume my table as look as below
column1 column2
1
a
1
a
2
b
11 matches
Mail list logo