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:[EMAIL PROTECTED] Sent: Friday, 30 September 2005 12:20 PM To: Martijn van den Burg Cc: mysql@lists.mysql.com; 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
