Tag Archives: database

Running MySQL queries in Python

Posted on March 20, 2009 by Samuel Huckins

Being able to access MySQL databases in Python opens up quite a wide range of possibilities. It’s essential for a number of tasks such as connecting disparate datasources, performing maintenance, running regular updates, and more. While there are a number … Continue reading →

Posted in MySQL, Programming | Tagged , , , , | 5 Comments

Finding the smallest or largest value across multiple columns in MySQL

Posted on March 20, 2009 by Samuel Huckins

A long title for a simple problem: You have a table containing several columns of, say, dates. You want to find out the first or last date among the values of these columns per row. Not too bad. But, you … Continue reading →

Posted in MySQL | Tagged , , , | 4 Comments

Creating better MySQL indexes: The basics

Posted on March 20, 2009 by Samuel Huckins

The well-developed MySQL platform allows anyone to play with a full-featured database just by following a few links and clicking through an install wizard. You can download it at home for free, and have access to the same high end … Continue reading →

Posted in MySQL | Tagged , , , | Leave a comment

Exploring the power of the mysql client

Posted on March 15, 2009 by Samuel Huckins

One of the things that surprised me at the MySQL Bootcamp was the focus on using the mysql CLI client. I used to only use this, since the GUI-based Query Browser was rather unstable on Linux. I just got tired … Continue reading →

Posted in CLI, MySQL | Tagged , , , , | 2 Comments

MySQL Bootcamp: Highly recommended!

Posted on March 14, 2009 by Samuel Huckins

I was able to attend the MySQL Bootcamp this week, and it was incredible. Instructors David Swain and George Trujillo really knew their stuff, and they did an admirable job sharing their experience and knowledge. They were an interesting pair, … Continue reading →

Posted in MySQL, Programming | Tagged , , | 1 Comment