Brain Goo

Carpe Crap ’em

Brain Goo header image 4

Ads help keep this site alive:


Entries Tagged as 'mysql'

SQL: Select duplicate rows, select indistinct rows

October 27th, 2008 · 1 Comment

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 […]

[Read more →]

Tags: How Tos · mysql · SQL

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 […]

[Read more →]

Tags: How Tos · mysql