Help with SQL commands plz

Hi there,

Guys i just started learning MySQL and was reading some tutorials. So, I have created the table in MySql in this way:

create table celphonedata (id int unsigned NOT NULL auto_increment, name varchar(20) NOT NULL, primary key(id));

Code (markup):

On this table I forgot to input data for mobile phone numbers and addresses. Can I modify this table in order to display mobile phone numbers and addresses as well?



Thanks in advance

 

Yes, you can. Use alter http://dev.mysql.com/doc/refman/5.1/en/alter-table.html.

ALTER TABLE celphonedata ADD phone_numbers VARCHAR(60);

Refer this. http://www.tech-recipes.com/rx/378/add-a-column-to-an-existing-mysql-table/