MySQL Error Number 1005 Can’t create table ‘.\mydb\#sql-328_45.frm’ (errno: 150) If you get this error while trying to create a foreign key, it can be pretty frustrating. The error about not being able to create a .frm file seems like it would be some kind of OS file permission error or something but this is [...]
Archive | October 22, 2006
MySQL Data Type Optimization Tips
A lot of people might classify this as a “newbie” piece. But, I would say that I’ve seen inefficient data usage plenty of times due to just laziness. Some people might even say “premature optimization is the root of all evil” and just make field sizes way bigger than they need. I like to try [...]
