Search found 16 matches

by walkerl26
Thu Apr 04, 2013 9:29 pm
Forum: Databases
Topic: DB denormalization and UI lookups
Replies: 4
Views: 1552

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...

Go to advanced search