Using MySQL 5.0.18
mysql> use test1;
Database changed
mysql> show tables;
+-----------------+
| Tables_in_test1 |
+-----------------+
| t1 |
+-----------------+
1 row in set (0.00 sec)
mysql> show create table t1 \G
***************** 1. row *****************
Table: t1
Create Table: CREATE TABLE `t1` (
`ID` int(11) NOT NULL auto_increment,
`set1` varchar(30) default NULL,
`col2` char(20) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='test1.t1 test table'
1 row in set (0.00 sec)
mysql> show full columns from t1 \G
***************** 1. row *****************
Field: ID
Type: int(11)
Collation: NULL
Null: NO
Key: PRI
Default: NULL
Extra: auto_increment
Privileges: select,insert,update,references
Comment:
***************** 2. row *****************
Field: set1
Type: varchar(30)
Collation: latin1_swedish_ci
Null: YES
Key:
Default: NULL
Extra:
Privileges: select,insert,update,references
Comment:
***************** 3. row *****************
Field: col2
Type: char(20)
Collation: latin1_swedish_ci
Null: YES
Key:
Default: NULL
Extra:
Privileges: select,insert,update,references
Comment:
3 rows in set (0.00 sec)
For some reason the
mysql> show full columns from t1 \G
command is not returning the Comment field for me. Is there
a variable that needs setting to enable this?
Regards
Keith
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
>
> 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
> mysql> 'commentaire');
> Query OK, 0 rows affected (0.03 sec)
>
> mysql> SHOW FULL COLUMNS FROM a_table;
> +----------+----------+------+-----+---------+-------+---------------------------------+
> | Field | Type | Null | Key | Default | Extra | Privileges
> | |
> +----------+----------+------+-----+---------+-------+---------------------------------+
> | a_column | char(30) | YES | | NULL | |
> | select,insert,update,references |
> +----------+----------+------+-----+---------+-------+---------------------------------+
> 1 row in set (0.03 sec)
>
>
> It seems this is a feature available for a more recent release.
>
> Is this right ?
>
>
>
>
> On Wed, 19 Apr 2006, 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)
> >
> > When creating a table you can add a comment using COMMENT keyword:
> >
> > CREATE TABLE a_table
> > (
> > a_column CHAR(30) CHARSET utf8 COMMENT 'Some comment'
> > ) ;
> >
> > Is this... what you needed ?
> >
> > --
> > Gabriel PREDA
> > Senior Web Developer
> >
>
> =_==_==_==_==_==_=
> =¯==¯==¯==¯==¯==¯=
> Gilles Missonnier
> IAP - [EMAIL PROTECTED]
> 01 44 32 81 36
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
