Search found 16 matches
- Thu Apr 04, 2013 9:29 pm
- Forum: Databases
- Topic: DB denormalization and UI lookups
- Replies: 4
- Views: 4032
Re: DB denormalization and UI lookups
Here's another approach I recently used with great success: Instead of storing an INT and using it as a foreign-key to the actual strings, make the status in the original table an ENUM instead. In your application, you can query the MySQL "information_schema" database and retrieve the list of ENUM v...