table comments
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
Re: table comments
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
Mysql merge table and table comments.
Hi! I have a simple question. Mysql version is 5.0.87 I have some merged tables. Can I alter 1 table and change a table comment? Is it legal? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Mysql merge table and table comments.
- Original Message - From: k...@inbox.lv I have some merged tables. Can I alter 1 table and change a table comment? Is it legal? As long as you don't change the table structure or name that shouldn't be a problem, I think. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Table comments truncated at 80 characters
Since upgrading from 4.x to 5.x we've found table comments to be truncated at 80 characters. Is this a configurable option somewhere and I just can't find it in the manual? Thanks, Russell. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Getting table comments
I have a short and simple question that I can't find an answer to. Is there a way to return table comments with a query? Thanks, -Jackson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Getting table comments
At 14:29 -0500 7/17/03, Jackson Miller wrote: I have a short and simple question that I can't find an answer to. Is there a way to return table comments with a query? SHOW CREATE TABLE t; SHOW TABLE STATUS LIKE 't'; Thanks, -Jackson -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]