can I add a new field to a table ?

[Anon]

Hi,
I have a table :
create table pcinfo(
IP_Address varchar(40) NOT NULL PRIMARY KEY,
User varchar(40) NOT NULL,
New_Name varchar(40) NOT NULL,
Domain varchar(40) NOT NULL,
Jack_Number varchar(40) NOT NULL,
OS varchar(40) NOT NULL,
PC varchar(40) NOT NULL,
Processor varchar(40) NOT NULL,
Memory varchar(40) NOT NULL
);

now I want to add a new field :
Note varchar(40) NOT NULL

is there a way to do it without dropping the table and recreate it again, because I don't want to lose data ?

thanks

[Anon]

http://www.mysql.com/doc/A/L/ALTER_TABLE.html

[mikesgt2]

ALTER TABLE pcinfo ADD Note varchar(40) NOT NULL;