// author archive

Randy

Randy has written 76 posts for @randymelder

Finding duplicate rows in MySQL

I saw this question online reading “How do I identify duplicate rows in MySQL” and it’s been gnawing at me so here’s my approach: Make a duplicate of your subject matter CREATE TABLE a2 LIKE a1; INSERT INTO a2 SELECT * FROM a1; Add a ‘checksum’ column to the new table ALTER TABLE a2 ADD […]

Things that make the USA Awesome!

I recently went on a vacation to some foreign lands. It gave me the opportunity to reflect on the things I love about the USA. Don’t get me wrong, we had a great time and there are some great things about other countries. However, in the end, I really did long for all things American […]

I started making this iOS game with Sprite Kit

Side benefits of jet lag + general insomnia include lots of time to learn new things. I decided it was time to learn Sprite Kit by making a game for my 2-year old to play on my iPhone. I call it “Say Shapes” – Here’s progress after 4 total hours.

Apple’s One Timezone planet

At midnight, the world timeclock gets label panic. Don’t ask me how I know…

Amazon Time Warp Fail

When you see it…

Yahoo! mail fail

We’re Sorry.

Facebook Actively Inactive :-(

You have activity! You have no activity?!?

LinkedIn lost its data link

AT&T location finder needs a server finder

I needed to find a store. AT&T needs to find an available server. Sad me.