Posted by Gordon Burditt on 11/14/45 11:21

>Oh, I see. I thought that the label would be part of the mySQL
>database. That should be something for the next release of mySQL.
>
>Thanks, Gordon!

Actually, it's already here in MySQL 5.0.7, although I don't know
whether phpMyAdmin uses it. In the virtual database 'information_schema',
table 'columns', there is a field 'column_comment' (varchar(255)).
You cannot, however, update it with UPDATE. I'm not sure how you
do update it. ALTER TABLE, I guess.

I've had some trouble with phpMyAdmin screwing things up with newer
versions of MySQL. Largely, it seems to be a problem with it not
knowing about features added after that version was written (e.g.
privileges, which have expanded a lot) and messing things up because
it doesn't know about them. And I suppose trying to deal with
comments across a variety of different MySQL versions, using native
methods where possible, must be very difficult to keep up with.

Gordon L. Burditt

[Back to original message]