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];
Many thanks to Justin for this great magic trick

Create network drive using ssh to window env.

OK. Before I start on this one, I’m stating for the record that I’m posting this as much so I don’t have to find it again as anything. However, given the number of places online that I found this question asked, but not answered, I hope it proves useful to the folks who’ve been looking for it. Lanjutkan membaca Create network drive using ssh to window env.

Correcting System Hang at Startup

If your system hangs about 2 or 3 minutes at startup, where you can’t access the Start button or the Taskbar, it may be due to one specific service (Background Intelligent Transfer) running in the background. Microsoft put out a patch for this but it didn’t work for me. Here’s what you do: Lanjutkan membaca Correcting System Hang at Startup

Swap File Tweak

For Users with 256 MB RAM or more this tweak will boost their Windows- and Game-Performance.
What it does: It tells Windows not to use any Swap File until there is really no more free RAM left.

Open the System Configuration Utility by typing msconfig.exe in the RUN command. There in your System.ini you have to add “ConservativeSwapfileUsage=1” under the Lanjutkan membaca Swap File Tweak

Boot XP faster

  1. Open notepad.exe, type “del c:\windows\prefetch\ntosboot-*.* /q” (without the quotes) & save as “ntosboot.bat” in c:\
  2. From the Start menu, select “Run…” & type “gpedit.msc”.
  3. Double click “Windows Settings” under “Computer Configuration” and double click again on “Shutdown” in the right window.
  4. In the new window, click “add”, “Browse”, locate your “ntosboot.bat” file & click “Open”.
  5. Click “OK”, “Apply” & “OK” once again to exit.
  6. From the Start menu, select “Run…” & type “devmgmt.msc”.
  7. Double click on “IDE ATA/ATAPI controllers”
  8. Right click on “Primary IDE Channel” and select “Properties”.
  9. Select the “Advanced Settings” tab then on the device 0 or 1 that doesn’t have ‘device type’ greyed out select ‘none’ instead of ‘autodetect’ & click “OK”.
  10. Right click on “Secondary IDE channel”, select “Properties” and repeat step 9.
  11. Reboot your computer.

HDD slowdown when booting

If you have a 3min+ or slower boot time where Windows XP seems to sit for 2+ or so minutes with the XP logo doing nothing before everything comes to life, then do the following.

Download Bootvis from Microsoft and run it the next time you boot. Do a ‘Trace’
If it shows a very long ‘HDD init’ time of minutes rather than seconds then this is how to fix it. Lanjutkan membaca HDD slowdown when booting