Using SQL, MySQL or whatever your favorite database may be, we all know using SELECT DISTINCT will return unique values in case a value appears more than once in a table.
How do you fine duplicates? What if I want to know where the duplicates are?
The trick is to use count() and compare it to [...]
Entries Tagged as 'How Tos'
SQL: Select duplicate rows, select indistinct rows
October 27th, 2008 · No Comments
Change or recover MySQL root password
September 22nd, 2008 · No Comments
To Change a Known Password
If you know the current password, use one of these methods to reset it. If you do not know, skip ahead to the next section.
Using mysqladmin if there is no password:
$ mysqladmin -u root password <new password>
Using mysqladmin if there is a password:
$ mysqladmin -u root -p <old password> <new password>
Using [...]
Windows 2003 Update Group Policy
August 29th, 2008 · No Comments
From Microsoft knowledgebase article http://support.microsoft.com/kb/298444
To update the group policy, run Gpupdate.exe from a cmd window. This is refresh any changes in the Group Policy as they apply to that machine. Run Gpupdate.exe /Force from a cmd window in order to force a full refresh of the Group Policy.
You have to check Event Log -> Application [...]
Tags: How Tos