MySQL auto-id function provides the ability to automatically create a new id for each new record on insert. This works great for unique ids, but sometimes more logic is required. For a recent assignment we needed to populate a table that reflects seating in a stadium. The seating was typical of most venues consisting of [...]
Archive | MySQL RSS feed for this section
MySQL Error Number 1005 Can’t create table ‘.\mydb\#sql-328_45.frm’ (errno: 150)
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 [...]
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 [...]
MySQL Client does not support authentication protocol
If you ever get this error when trying to connect your application to a MySQL server, it’s because as of 4.1 MySQL made changes to the authentication method used. Most hosts are still running PHP that does not support this new authentication and so any application (PHPBB, etc) that you try to install won’t work. [...]
