alter table it add title varchar(50); "Carlos Williams" <carlosw...@gmail.com> escreveu na mensagem news:d80f793f0909300945n73394480j468c2cf76dc9c...@mail.gmail.com... >I am no doubt very new to MySQL and have been studying the on line > manual however I find it a bit complex and don't understand what it's > suggesting I do in this case. I created a database called 'staff' and > then in that database I created one simple table: > > mysql> show tables; > +-----------------+ > | Tables_in_staff | > +-----------------+ > | it | > +-----------------+ > 1 row in set (0.00 sec) > > mysql> describe it; > +----------+-------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +----------+-------------+------+-----+---------+-------+ > | name | varchar(40) | YES | | NULL | | > | username | varchar(20) | YES | | NULL | | > | email | varchar(20) | YES | | NULL | | > | office | char(3) | YES | | NULL | | > +----------+-------------+------+-----+---------+-------+ > 4 rows in set (0.00 sec) > > My question is if I would like to add addition fields like 'title' & > 'phone number', how can I modify the table fields entry to add more > fields? Thanks for any help!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
