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>
