MySQL - Coffee on the Keyboard

MySQL

A collection of 4 posts

Mistakes: Importing Data with MySQL

I spent the better part of today trying to import—in various attempts—between 800 MB and 3.1 GB of data into a local MySQL server. The whole time I was Doing It Wrong™. Now I feel like this [http://www.flickr.com/photos/zachklein/54389823/]: I was using

Responsible SQL: How to Authenticate Users

Most SQL-injection articles set a horrible example for young programmers. Here is a very typical “bad example” of why you need to escape user data before it goes into SQL queries: (ed. The symbol « is a line break that’s not in the real code.) 1. $username = $_POST[‘username’]; // username=

Help Me Scale

I’ve been reading Eran Hammer-Lahav’s intelligent [http://www.hueniverse.com/hueniverse/2008/04/scaling-a-micro.html] posts on [http://www.hueniverse.com/hueniverse/2008/03/scaling-a-micro.html] microblog scalability [http://www.hueniverse.com/hueniverse/2008/03/on-scaling-a-mi.html], and now I’m concerned about my own “microblog” site, Picofiction

MySQL Subqueries

I often find it difficult to find tips and advice for doing relatively simple things in things like MySQL, Ruby, Python, etc. So, starting with this post, I will help fill that niche. Today’s topic is Using Subqueries to Simplify your SQL Queries. For this article, I’m using