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]