I'm thinking of using the "COMMENT" of columns when
creating tables to store some metadata about the
column, for instance: valid_range of numbers,
validation regexp, etc.
I did some tests with including this information as
then be easily decoded into an actual data structure
for the scripting language (Python in my case) being
used. The setup seems to work well.
One shortcoming is that the maximum size of a COMMENT
is 256 characters.
Do you have any comments about this approach?
What could possibly go very bad about relying on
this usage of the COMMENT?
I am currently using mysql 5.0.27-standard-log.
Thanks in advance for your comments,