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



> > > 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.
>
> I did and it still works (maybe the behaviour is version
> dependent?).

Hmm, could be.

I remember all sorts of information being returned in the
COMMENTS section, all that was different from my
actual comment :-)


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