Posts about mysql

10
Feb
2019

Recursive Queries with MySQL

Discovered something neat with the new version of MySQL and thought it warranteda mention. Storing tree structures in a relational database is a common use caseacross many different areas of...
28
Jun
2018

Backing Up and Rotating MySQL Databases the Easy Way

Here's a little quickie for you. Say you have a small MySQL server floating around your house that you want to have regular backups of. You do want regularbackups right?...
18
Aug
2016

Finding Multi-byte Characters in MySQL Fields

So I was recently helping a client with an issue in MySQL where a migrationfailed to transfer the full contents of some fields. This amounted to a littleover 1% of...
9
May
2011

MySQL mathematical operations and NULL values

So I came across an interesting quirk in MySQL the other day. Let's say you have a table schema and some values that look like this:+-------------------+------------------+------+-----+---------+-------+| Field             | Type             |...
27
Feb
2011

BASH Quickie: Backing Up MySQL Databases

In some ways, after years of doing programming and scripting, I'm now sort of rediscovering the power of the shell.Tonight, I was working on my server and remembered that I...
4
Mar
2010

MySQL Conference, Santa Clara, CA

I’ll be attending MySQL Conference in Santa Clara, California this year. This will actually be my first time attending this conference, so I’m looking forward to it.Also, my coworker Brian...
13
Feb
2010

MySQL-based Apache HTTP Authentication for Trac and Subversion

In working on a side project with a few friendly developers, we decided to set up a Subversion repository and a Trac bug and issue tracker. Both of these, in...