#826 (in 2.7.1) Column comments - make editable / more visible

fixed
1
2013-06-11
2005-11-21
mvl22
No

PhpMyAdmin now has basic support for column comments,
which is very welcome:
http://www.phpmyadmin.net/home_page/downloads.php?
relnotes=3

However, this only extends to readability when
listing the data dictionary (in db_datadict.php ).

Given that MySQL 4.1 now supports native column
comments, it would be very useful indeed to be able
to add/edit these directly in MySQL.

1) It would certainly be good to show them when
listing the table properties:
tbl_properties_structure.php

2) However, more importantly, the ability to create
the comments in the first place, in
tbl_create.php

3) and when editing column names, as in tbl_alter.php

Comments seem to be very much the same as any other
of the metadata (like NULL,Extra,Default, etc)
associated with a column, so presumably the code need
not be too difficult to introduce.

I for one would find this an extremely useful
addition to PhpMyAdmin.

Discussion

  • Michal Čihař

    Michal Čihař - 2005-11-23

    Logged In: YES
    user_id=192186

    You can currently edit them, however only when internal
    relation/comment stuff is enabled.

     
  • Michal Čihař

    Michal Čihař - 2005-11-23
    • assigned_to: nobody --> nijel
    • status: open --> open-accepted
     
  • Michal Čihař

    Michal Čihař - 2005-11-23

    Logged In: YES
    user_id=192186

    Implemented in CVS.

     
  • Michal Čihař

    Michal Čihař - 2005-11-23
    • labels: --> Data insertion/extraction/manipulation
    • priority: 5 --> 1
    • summary: Column comments - make editable / more visible --> (in 2.7.1) Column comments - make editable / more visible
    • status: open-accepted --> open-fixed
     
  • mvl22

    mvl22 - 2005-11-23

    Logged In: YES
    user_id=1232666

    > Implemented in CVS.

    MySQL 4.1 -style native comments you mean? Excellent -
    thank you very much indeed for the quick response and
    implementation of this.

     
  • Michal Čihař

    Michal Čihař - 2005-11-23

    Logged In: YES
    user_id=192186

    The infrastructure was already there, only it was not used
    in all cases.

     
  • mvl22

    mvl22 - 2005-12-05

    Logged In: YES
    user_id=1232666

    What release will this useful fix make it into? I see 2.7.0
    final hasn't included it, as far as I can see (or at least,
    having downloaded it, I see no change).

     
  • Michal Čihař

    Michal Čihař - 2005-12-05

    Logged In: YES
    user_id=192186

    It will be in 2.7.1, see summary :-). It was too late to
    include this in 2.7.0.

     
  • Davy Defaud

    Davy Defaud - 2005-12-28

    Logged In: YES
    user_id=1203681

    I was really missing this functionality that the
    mysql-query-browser was implementing!
    Personally I use field comments as my web forms labels and I
    find this very convenient.

    I was about to send a feature request when I found this post.
    It seems that I'm not the only one wanting such a feature!...

    Thanks everybody :-)

     
  • Marc Delisle

    Marc Delisle - 2006-03-06
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed
     

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

Sign up for the SourceForge newsletter:





No, thanks