Hello
I have 4.1.0-alpha-max-nt. When i issue a command -
show full fields from tblname;
I get information about the fields in the table. There
are two columns i.e. EXTRA and COMMENTS which is
always blank. I cant seem to figure out what
information they provide. The SHOW FULL FIELDS... in
my My
Karam Chand <[EMAIL PROTECTED]> wrote:
>
> I have 4.1.0-alpha-max-nt. When i issue a command -
>
> show full fields from tblname;
>
> I get information about the fields in the table. There
> are two columns i.e. EXTRA and COMMENTS which is
> always blank. I cant seem to figure out what
> informa
How can I add comment to a column?
karam
--- Egor Egorov <[EMAIL PROTECTED]> wrote:
> Karam Chand <[EMAIL PROTECTED]> wrote:
> >
> > I have 4.1.0-alpha-max-nt. When i issue a command
> -
> >
> > show full fields from tblname;
> >
> > I get information about the fields in the table.
> There
> >
Karam Chand <[EMAIL PROTECTED]> wrote:
> How can I add comment to a column?
Use COMMENT keyword:
CREATE TABLE test(
id int NOT NULL auto_increment COMMENT 'this is a comment',
PRIMARY KEY (id)
) TYPE=MyISAM;
>
> karam
> --- Egor Egorov <[EMAIL PROTECTED]> wrote:
>> Karam Chand <[EMAIL PROTECTE