Hi Jonas,
From the manual
A comment for a column can be specified with the COMMENT option. The
comment is displayed by the SHOW CREATE TABLE and SHOW FULL COLUMNS
statements. This option is operational as of MySQL 4.1. (It is allowed
but ignored in earlier versions.)
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-----Original Message-----
From: Jonas Geiregat [mailto:yux@stripped]
Sent: Friday, 30 September 2005 12:20 PM
To: Martijn van den Burg
Cc: mysql@stripped; Siegfried Heintze
Subject: Re: Where to store comments?
Martijn van den Burg wrote:
>On Wednesday 28 September 2005 20:47, Siegfried Heintze wrote:
>
>
>>Other databases allow one to store comments describing each field in a
>>table definition. These are stored in the database. In addition, one
can
>>store comments about the table. Examples include MS SQL Server and MS
>>Access.
>>
>>Does MySQL have such a feature? Is there a GUI to support it?
>>
>>
>
>Short answer: yes.
>Long answer: http://dev.mysql.com/doc/mysql/en/create-table.html
>
>I guess that MySQLCC or MySQL Administrator could deal with this, but
I'm not
>sure since I orefer the command line :)
>
>
>
Doesn't seem to work here,
mysql> create table foo (id int NOT NULL comment 'test foo en bar');
Query OK, 0 rows affected (0.02 sec)
mysql> show create table foo;
+-------+---------------------------------------------------------------
---------+
| Table | Create
Table |
+-------+---------------------------------------------------------------
---------+
| foo | CREATE TABLE `foo` (
`id` int(11) NOT NULL default '0'
) TYPE=MyISAM |
+-------+---------------------------------------------------------------
---------+
1 row in set (0.00 sec)
mysql> desc foo;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id | int(11) | | | 0 | |
+-------+---------+------+-----+---------+-------+
1 row in set (0.00 sec)
mysql> select version();
+-----------+
| version() |
+-----------+
| 4.0.25 |
+-----------+
1 row in set (0.00 sec)
mysql>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
