Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#32 Show full definition for ENUM and SET types

open
John Currier
None
5
2006-11-21
2006-11-17
Erik Meitner
No

Columns of MySQL ENUM or SET types show in the generated report as only 'enum' or 'set'. It would be usefull if the full field definition was shown, eg: set('123',abc','zyx')

Discussion

  • John Currier
    John Currier
    2006-11-21

    Logged In: YES
    user_id=1264584
    Originator: NO

    Sounds like a useful enhancement. Would you happen to know the SQL to extract that info?

    John

     
  • John Currier
    John Currier
    2006-11-21

    • assigned_to: nobody --> johncurrier
     
  • Erik Meitner
    Erik Meitner
    2006-11-30

    Logged In: YES
    user_id=907094
    Originator: YES

    "show create table the_table_name;"
    Can return data like:
    ... `LineItemType` enum('scan','dept-sale','discount','coupon') default NULL ...
    or
    ... `ApplicableTaxes` set('1','2','3','4','5','6','7','8') default NULL ...

    http://dev.mysql.com/doc/refman/5.1/en/show-create-table.html

     
  • John Currier
    John Currier
    2006-12-01

    Logged In: YES
    user_id=1264584
    Originator: NO

    Ugh, that approach makes it extremely difficult to extract that information in a db vendor-independent manner. I'd have to parse through the returned resultset in a MySQL-specific manner, right?

    John