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