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 definition, as documented in the manual
http://dev.mysql.com/doc/refman/5.0/en/create-table.html
[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
http://dev.mysql.com/doc/refman/5.0/en/create-table.html.
column_definition:
col_name type [NOT NULL | NULL] [DEFAULT
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
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
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
hello,
thank you for your answer, but
this DO NOT work for me. I
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
: 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
--
MySQL General Mailing List
Hello
I run MySql 4.0.24 [ the release for the Debian stable Linux ].
when I do a describe a_table, it displays the 6 following columns :
Field - Type - Null - Key - Default - Extra
It would be nice if I could have a 7th column for a comment
that could be used to describe the meaning of a
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)
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
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
Hello
when I do a describe a_table, it displays :
| Field | Type | Null | Key | Default | Extra |
I would like to have a Comment that would show
the meaning of a field. Extra is to be used for othe info.
I looked around at :
http://se2.php.net/manual/en/function.mysql-field-name.php
but
12 matches
Mail list logo