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 > > 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 MySQL Doc does not talk on this columns. > > Extra shows if column has attribute AUTO_INCREMENT. > Comments shows comment on the column level. For > example: > > mysql> show full fields from test; > +-------+---------+-----------+------+-----+---------+----------------+---------------------------------+-------------------+ > | Field | Type | Collation | Null | Key | Default > | Extra | Privileges | > Comment | > +-------+---------+-----------+------+-----+---------+----------------+---------------------------------+-------------------+ > | id | int(11) | NULL | | PRI | NULL > | auto_increment | select,insert,update,references | > this is a comment | > +-------+---------+-----------+------+-----+---------+----------------+---------------------------------+-------------------+ > 1 row in set (0.01 sec) > > > > > -- > For technical support contracts, goto > https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net > http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ > [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] >
__________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
