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]
