I'm relatively new to MySQL and am drawing up some ideas for writing a
support/trouble tracking database for my company. I envisioned a single
database with seperate tables for various data I would be storing
(IP/Connection info table, Machine Inventory Table, etc). Each table would
have data for
Can someone help me with a query to pull all possible values for an enum
column? I found this in the online manual, but it doesn't seem to work for
me.
If you want to get all possible values for an ENUM column, you should use:
SHOW COLUMNS FROM table_name LIKE enum_column_name and parse the ENUM
