From: João Cândido de Souza Neto (joaoconsultorweb.cnt.br)
Date: Wed Sep 30 2009 - 11:51:34 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

alter table it add title varchar(50);

"Carlos Williams" <carloswillgmail.com> escreveu na mensagem
news:d80f793f0909300945n73394480j468c2cf76dc9c7d8mail.gmail.com...
>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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]