[UPHPU] MySQL Question

Mr Ritter uphpu at candlefire.org
Tue Aug 7 12:46:26 MDT 2007


ALTER TABLE `blah` COMMENT = 'this is for testing'

Can be seen with: SHOW CREATE TABLE `blah`;

With MySQL 5.0.x there is a `information_schema` database as well as the 
`mysql` database. These table comments are stored in: 
`information_schema`.`tables`.`table_comment`

Simply query this database/table or join with another query.

Hope that helps.

--
Ritter




More information about the UPHPU mailing list