COMMENTS in INFORMATION_SCHEMA

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
BB [ Di, 30 Januar 2007 16:35 ] [ ID #1612716 ]
Datenbanken » mailing.database.mysql » COMMENTS in INFORMATION_SCHEMA

Vorheriges Thema: Stored Procedure problem
Nächstes Thema: importing nonprintable delimiters with mysql ?