Carlos,
Get a free copy of SqlYog (Community edition).
http://code.google.com/p/sqlyog/
Mike
At 11:45 AM 9/30/2009, you wrote:
>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=1
