Monthly Archives: February 2011

Why I don’t use enum columns in MySQL database design

Posted on February 21, 2011 by Pete

I used to be a fan of ENUM columns in MySQL databases. They’re lighter-weight than explicit lookup tables and, I presumed, led to less expensive operations than foreign key checks on a lookup table. But I’ve changed my mind: Changes … Continue reading →

Posted in Geek, Technologies | Tagged Databases, Enumerated type, Lookup table, mysql, SQL | Leave a comment