Brad Bloomfield

technologist, musician, 4wd enthusiast and amateur radio operator

MySQL CONCAT — a really handy function

I often use the MySQL string concatenation function concat. It is really awesome and makes my life easier. So I’ll take you through a…

Brad Bloomfield1 min read

MyISAM — An old but still really useful storage engine

It’s been that INNODB has been the default MySQL storage engine for some years. For good reason, foreign keys and index level locking make…

Brad Bloomfield3 min read

MySQL Prepared Statements

I recently developed a PHP script to export some denormalised data out of a set of MySQL tables. The original authors of the system we…

Brad Bloomfield2 min read

Collections edited by Brad Bloomfield

MySQL — Interesting queries for reporting and analysis