Sometimes you may feel the need to re-order the fields in one of your tables - you shouldn’t really have to do this, but some people prefer a ‘neat’ schema. The most obvious way of doing this is to recreate the entire table, or drop the field and recreate it, but there is an easier way that doesn’t involve dropping fields or tables. (more…)

At some point you will encounter the error message “Too many connections” - given that the MySQL database server has three different connection limits, it’s important to know which limit you’ve hit, and what you can do about it. (more…)