Posts about mysql

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...