Remove duplicate entry on mysql record | Hendra Kharisma

Subscribe:
Posts
Comments
Email

Remove duplicate entry on mysql record

Posted by hendra on August 31, 2008, filed in: Blogging

1

When I have very lot of duplicate entry in my database, I searching on the net about how to eliminate unnecessary entry on my Database.

Sponsorship

Here’s the magic command I found on the net.

CREATE TABLE new_table AS
SELECT * FROM old_table WHERE 1 GROUP BY [COLUMN TO remove duplicates BY];

Many thanks to Justin for this great magic trick

Similar Posts:

How do I add jobs to cron under Linux or UNIX oses? [5 Comment(s)]
How To Setup a Wi-Fi Hotspot [14 Comment(s)]
Protected: Tips belajar PHP [6 Comment(s)]
Boot XP faster [1 Comment(s)]
Create network drive using ssh to window env. [1 Comment(s)]

Tags: Mysql, Tutorials

« Previous

Create network drive using ssh to window env.

Next »

Selamat tinggal Firefox, Selamat datang Google Chrome

One Response

keersuddy says:

January 30, 2009 at 16:36

not counting cialis ungenuine

Reply

Leave a Reply

© 2008 Hendra Kharisma. All rights reserved.

Proudly designed by Theme Junkie.