From: mos
Date: September 30 2009 5:11pm
Subject: Re: Adding Fields To Table
List-Archive: http://lists.mysql.com/mysql/218892
Message-Id: <6.0.0.22.2.20090930121110.02b63f98@mail.messagingengine.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

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=mos99@stripped