Bug #27661 fields comments - storage engines
Submitted: 5 Apr 2007 4:19 Modified: 18 Sep 2014 19:55
Reporter: Roberto Spadim (Basic Quality Contributor) Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:all OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: coments, storage engine
Triage: D5 (Feature request)

[5 Apr 2007 4:19] Roberto Spadim
Description:
hello guys, today we have comments for tables, ok that's very good we can understand for what each table exists,
could we implement this on fields? fields could have an auto explanation
like:

(for item table)
sale_price - total sale price
(for total acount table)
sale_price - total to pay

thanks, this could be implemented in every storage engines

How to repeat:
alter table
change field_name field_new_name type(size,precision) default 'value' comments 'well with this tool i could make a self explain manual of my tables :D'
[5 Apr 2007 4:19] Roberto Spadim
maybe another file one for each table, or the .frm file could allow us to implement this without many modifications
[20 Apr 2007 3:03] Roberto Spadim
hello guys, i still need filed comments, i'm using some datetime fields, they are gmt and tz referenced, i always need check PHP source to know what type they are :/

please patch server on the next release please :)
[6 Dec 2007 15:21] Trudy Pelzer
Done in MySQL 6.0; WL#3736.
[18 Sep 2014 19:55] Roberto Spadim
please update the SHOW COLUMNS to show this comment info