Adding to an existing Table

I have a program that I purchased that uses MySQL and PERL DBI. I ran into a problem where they preset the "title" column to 35 lenght, and I got that solved where it will allow 45 now. The problme I have now is I need to add at least 3 more columns to an existing table. I'm assuming I use the INSERT INTO command at the mysql prompt...but is there anything I should beware of, or am I barking up the wrong tree? ALSO: if I do attempt to add a new column to an existing database, how do I delete the column with out deleting the entire database??? Thank you in advance for your help!

Brant
Webnautics

you can add columns to a table by using the following code where your table is named "mytable":
ALTER table mytable ADD mycolumn INT(2);
ALTER table mytable DROP mycolumn;

for more information on this visit the mysql tutorial here on devshed. http://www.devshed.com/Server_Side/...ntro/page5.html
Good Luck