COMMENTS in INFORMATION_SCHEMA

COMMENTS in INFORMATION_SCHEMA

am 30.01.2007 16:35:54 von BB

Hi There,
just moved over from SQL Server to mySQL and finding my way about. In
SQL Server there was a way of retrieving (and setting) metaproperties
for columns and tables. The closest I see to this is the
TABLES.table_comment COLUMNS.column_comment fields in the
INFORMATION_SCHEMA 'Database'.

How do you set these values? Seems like you cannot amend values within
these tables. I am using version 5.0.27.

Thanks
BB