Posted by hendra in 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.
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?
- How To Setup a Wi-Fi Hotspot
- Protected: Tips belajar PHP
- Boot XP faster
- Create network drive using ssh to window env.
Extend This Post Reach
not counting cialis ungenuine