Hello Martin, On 9/7/2014 7:42 PM, Martin Mueller wrote:
The TABLES table in MySQL's information_schema has a TABLE_COMMENT column. Could one use that for ad hoc and manual annotation of that table? And if so, could one change its length? Or are there better ways of producing table notes that are kept with the database, as opposed to Evernote or some notebook where you never find it again? Martin Mueller Professor emeritus of English and Classics Northwestern University
Every table, every database, and every column all have places in their definitions to place a comment. No, the sizes of the columns cannot be changed. Sorry.
To see how to set a comment, check out the appropriate ALTER or CREATE command for the object you want to annotate.
http://dev.mysql.com/doc/refman/5.6/en/sql-syntax-data-definition.html Yours, -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
