Category Archives: How Tos

SQL: Select duplicate rows, select indistinct rows

Posted on October 27, 2008 by admin

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 … Continue reading →

Posted in How Tos, mysql, SQL | Tagged , , | 1 Comment

Change or recover MySQL root password

Posted on September 22, 2008 by admin

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 … Continue reading →

Posted in How Tos, mysql | Tagged , | Leave a comment

Windows 2003 Update Group Policy

Posted on August 29, 2008 by admin

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 … Continue reading →

Posted in How Tos, microsoft, windows 2003 | Tagged , , | Leave a comment