Hi,
Gabriel PREDA wrote:
It is:
SHOW FULL COLUMNS FROM a_table
You will get 2 extra columns:
- Privileges (showing the privileges of the user for that column)
- Comment (showing a per column comment)
As well as "Collation" (the columns collation).
When creating a table you can add a comment using COMMENT keyword:
CREATE TABLE a_table
(
a_column CHAR(30) CHARSET utf8 COMMENT 'Some comment'
);
Is this... what you needed ?
--
Gabriel PREDA
Senior Web Developer
Best regards
Mark
--
Mark Leith, Support Engineer
MySQL AB, Worcester, England, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
