Finding Duplicate Records in MySQL
Digging around today I found a query that will identify duplicate records in a MySQL database.
SELECT id, count(*) as n
FROM table_name
GROUP BY id
HAVING n > 1
Updates from June, 2008 Toggle Comment Threads | Keyboard Shortcuts
-
ikazuchi
-
ikazuchi
Rek Stoneblade Character Background
The skies above the Sword Plains were clear, letting the stars light the village Tzai. The last days of winter had gone to where seasons die and the spring brought frequent rains. Tonight though, the sky was clear and the stars shone brightly. Devos, the green moon, hung low and full in the sky, the waning slivers of her celestial sisters having set hours ago.
Tzai was a small village, by human standards, having fewer than a hundred residents. A barbaric village composed of dozens of yurts and three stone buildings. Dirt paths wound through the village and the smell of horses was thick on the air. A backwater village in the center of plains that no larger nation bothered to claim. To the caldashi though, the half-orcs who ranged the Sword Plains, it was the home of the Gol, their lord and champion, and the Sword Plains was their empire.
North of Tzai, past the yurts, past the horse pens, beyond even the rice paddies and the fields of crops tended by the peasants, lies a circle of blue stones. The stones mark the boundary of Gu Hash Kinnuth, a sacred place which is home to the Monolith of Harmony and Enlightenment. The Monolith is a finger of granite that thrusts itself out of the flat plains as if the earth was reaching for the heavens. Three paces across and almost a dozen paces tall, the monolith is but one of more than a dozen such stone outcroppings like it across the Sword Plains. All are sacred to the caldashi, and tonight, like every night, the monolith burns with ghostly green flames.
(More …) -
ikazuchi
CthuluCarols
Honestly, I really hate the ‘holidays’. One of the things I hate the most are the ceaseless repetitions of Christmas carols. Abominable to begin with, their unending iterations are the thing to drive men mad (and I do not mean crazy).
A few years back I came across some carols a bit more tolerable. Read on for some amusing parodies of songs I’m sure you’ll hear dozens, if not scores, of times in the upcoming months.
-
ikazuchi
Site Genres
Recently, I was talking with some coworkers of mine and I was explaining my opinion that there are really only three main genres of sites that I can think of.
- Entertainment
- Reference
- Application
-
ikazuchi
Thinking Differently: A Story
Another story that I have no idea of the origin, but it exemplifies my love of thinking outside the box (to use an exhausted cliché).
-
ikazuchi
-
ikazuchi
Apache mod_rewrite Statement to Force HTTPS
<directory /var/www/X>
RewriteEngine On
RewriteCond %{HTTPS} off
RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI}
</directory>
-
ikazuchi
Reloading Process
Gah…So in the process of upgrading WordPress I completely obliterated something to the point that I cannnot upgrade my database properly. So now I find myself in the unenviable position of having installed the latest version of WordPress and having to go through the old database that I have archived off in SQL and rebuild all of my posts.