> > > 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?).
> > 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?).
Here is what I di
> > > 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
On 9/17/07, Martijn Tonies <[EMAIL PROTECTED]> wrote:
> > 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 re
Hi,
> I'm thinking of using the "COMMENT" of columns when
> creating tables to store some metadata about the
> column, for instance: valid_range of numbers,
> validation regexp, etc.
>
> I did some tests with including this information as
> a JSON (JavaScript Object Notation) string which can
> th
Hi,
I'm thinking of using the "COMMENT" of columns when
creating tables to store some metadata about the
column, for instance: valid_range of numbers,
validation regexp, etc.
I did some tests with including this information as
a JSON (JavaScript Object Notation) string which can
then be easily de
MAIL PROTECTED]>
To: "ViSolve DB Team" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, February 09, 2007 6:54 AM
Subject: Re: revoke SELECT on a column [ MySQL 4.1 ] + column "Comment"
Hello,
thanks again to ViSolve DB Team.
so, it turns out that for MySQL4.1, il will h
QUESTION concerns column "Comment"
In MySQL 5, I can do :
mysql> select column_name,COLUMN_COMMENT from information_schema.columns
where table_schema="a_base" and table_name='a_tab';
in MySQL 4.1 , the "equivalent" would be :
mysql>
> Basically, what I would like to do is associate a human readable label
with
> each column (in the comment field) so that I can automatically generate
> web-based forms for any given table. The script would look at the column's
> metadata, display the appropriate HTML element, and display the
> co
Hi,
I am aware of the fact that with 4.1.0, you can specify comments on a column
by column by basis. I was wondering if this functionality could somehow be
simulated in 4.0.x? It is high priority for me, but I cannot deploy the
alpha stage 4.1.0 in a production environment.
Basically, what I woul
10 matches
Mail list logo
