From: Martijn Tonies
Date: October 1 2009 7:02am
Subject: Re: Adding Fields To Table
List-Archive: http://lists.mysql.com/mysql/218900
Message-Id: <005101ca4265$26e76730$1401a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="UTF-8";
	reply-type=original
Content-Transfer-Encoding: 7bit

Hello Carlos,

>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!

The manual has a section on how to create and modify your metadata,
I suggest you take a look, it explains all.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com