From: Martijn Tonies
Date: September 17 2007 9:52am
Subject: Re: using column "comment" to store metadata
List-Archive: http://lists.mysql.com/mysql/209131
Message-Id: <02d301c7f910$87fb3a10$9902a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: 7bit

> > > Do you have any comments about this approach?
> > > What could possibly go very bad about relying on
> > > this usage of the COMMENT?
> >
> > Yes, in different storage engines, different stuff is returned.
> >
> > For example, in InnoDB, what you get returned from
> > SHOW FULL COLUMNS is not what you stored in the
> > "Comment" part.
>
> I currently use MyISAM, but I just tried a simple
> create(InnoDB)/show full columns from/  and
> it actually does return the JSON strings I put in.

Try it on columns with a foreign key constraint.



Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com