Karam Chand <[EMAIL PROTECTED]> wrote: > How can I add comment to a column?
Use COMMENT keyword: CREATE TABLE test( id int NOT NULL auto_increment COMMENT 'this is a comment', PRIMARY KEY (id) ) TYPE=MyISAM; > > 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]