Re: Where to store comments?
In article [EMAIL PROTECTED], Jonas Geiregat [EMAIL PROTECTED] writes: mysql create table foo (id int NOT NULL comment 'test foo en bar'); This is a comment on a column which apparently gets displayed by SHOW CREATE TABLE only by later versions, e.g. 4.1.14. Table comments go after the closing parenthesis: create table foo (id int NOT NULL) comment 'test foo en bar'; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
RE: Where to store comments?
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]
Where to store comments?
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? What perl or java functions does one use to store and retrieve these strings? Thanks, Siegfried -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Where to store comments?
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 :) What perl or java functions does one use to store and retrieve these strings? I haven't tried, but I suppose that you could retrieve the table information (using the SQL statement 'SHOW CREATE TABLE') and parse the resulting text in some way. Regards, -- /Martijn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]