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
