Agustus 2008

Remove duplicate entry on mysql record

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];...

Continue reading...

Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /home/enamyid/public_html/hendra-k.net/wp-includes/functions.php on line 5427

Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /home/enamyid/public_html/hendra-k.net/wp-includes/functions.php on line 5427