#32 Show full definition for ENUM and SET types

open
None
5
2006-11-21
2006-11-17
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

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks