hello,
thank you for your answer, but
this DO NOT work for me. I use MySQL 4.0.24 [ Linux Debian sarge stable ].
the "FULL" argument displays ONLY the Privileges, NOT the Comment, neither
Collation.
mysql> CREATE TABLE a_table (a_column CHAR(30) COMMENT 'commentaire');
Query OK, 0 rows affected (0.03 sec)
mysql> SHOW FULL COLUMNS FROM a_table;
+----------+----------+------+-----+---------+-------+---------------------------------+
| Field | Type | Null | Key | Default | Extra | Privileges
|
+----------+----------+------+-----+---------+-------+---------------------------------+
| a_column | char(30) | YES | | NULL | |
select,insert,update,references |
+----------+----------+------+-----+---------+-------+---------------------------------+
1 row in set (0.03 sec)
It seems this is a feature available for a more recent release.
Is this right ?
On Wed, 19 Apr 2006, 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)
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
=_==_==_==_==_==_=
=¯==¯==¯==¯==¯==¯=
Gilles Missonnier
IAP - [EMAIL PROTECTED]
01 44 32 81 36
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
