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]
