Re: describe table : improvement

sen <[EMAIL PROTECTED]> > Subject: Re: describe table : improvement > > [EMAIL PROTECTED] wrote: > > Thankyou Gabriel. > > > > So how does one set a column comment then? > > > > Regards > > > > Keith > > As part of the column defi

Re: describe table : improvement

[EMAIL PROTECTED] wrote: Thankyou Gabriel. So how does one set a column comment then? Regards Keith As part of the column definition, as documented in the manual . column_definition: col_name type [NOT NULL | NULL] [DEFAULT d

Re: [SPAM] Re: describe table : improvement

TECTED]> > Subject: [SPAM] Re: describe table : improvement > > COLUMN COMMENTs are not the same as TABLE COMMENT... > > For TABLE COMMENT you should use: > > SHOW TABLE STATUS LIKE 'table_name' > > *Gilles *(the starter of the thread) wanted COLUMN CO

Re: describe table : improvement

COLUMN COMMENTs are not the same as TABLE COMMENT... For TABLE COMMENT you should use: SHOW TABLE STATUS LIKE 'table_name' *Gilles *(the starter of the thread) wanted COLUMN COMMENTs. -- Gabriel PREDA Senior Web Developer

Re: describe table : improvement

th In theory, theory and practice are the same; in practice they are not. On Thu, 20 Apr 2006, Gilles MISSONNIER wrote: > To: Gabriel PREDA <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > From: Gilles MISSONNIER <[EMAIL PROTECTED]> > Subject: Re: describe table : improvement > >

Re: describe table : improvement

Sorry forgot to mention MySQL version 4.1.X > This option is operational as of MySQL 4.1. (It is allowed but ignored in > earlier versions.) -- Gabriel PREDA Senior Web Developer

Re: describe table : improvement

hello, thank you for your answer, but this DO NOT work for me. I use MySQL 4.0.24 [ Linux Debian sarge stable ]. the "FULL" argument displays ONLY the Privileges, NOT the Comment, neither Collation. mysql> CREATE TABLE a_table (a_column CHAR(30) COMMENT 'commentaire'); Query OK, 0 rows affec

Re: describe table : improvement

Hi, Gabriel PREDA wrote: It is: SHOW FULL COLUMNS FROM a_table You will get 2 extra columns: - Privileges (showing the privileges of the user for that column) - Comment (showing a per column comment) As well as "Collation" (the columns collation). When creating a table you can add

Re: describe table : improvement

It is: SHOW FULL COLUMNS FROM a_table You will get 2 extra columns: - Privileges (showing the privileges of the user for that column) - Comment (showing a per column comment) When creating a table you can add a comment using COMMENT keyword: CREATE TABLE a_table ( a_column CHAR(30) CHARS

Re: describe table : improvement ?

U can use instead of *DESCRIBE a_table* ** Another syntax: *show [full] columns from `a_table`* Without FULL it will act like *DESCRIBE a_table *but with FULL option you will get the comments on the column... and also another beautiful column witch will show you the privileges you have for each co