Bug #7400 comment for column
Submitted: 18 Dec 2004 10:04 Modified: 18 Dec 2004 10:57
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version: 4.0.22-standard OS: Linux 2.4.21-20.0.1.EL
Assigned to: CPU Architecture:Any

[18 Dec 2004 10:04] [ name withheld ] 
Description:
Hi
if I put a commet for a column in the Table  Editor, I apply the change and execute sql. When I close and I open again the editor, the comment are missing.
Daniele

How to repeat:
try to put a comment for a column in the Tabel Editor of MYSqlAdministrator
[18 Dec 2004 10:57] MySQL Verification Team 
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

From the MySQL manual:

A comment for a column can be specified with the COMMENT option. The comment is displayed by the SHOW CREATE TABLE and SHOW FULL COLUMNS statements. This option is operational as of MySQL 4.1. (It is allowed but ignored in earlier versions.)