March 15th, 2000, 11:27 PM
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!
March 16th, 2000, 12:22 AM
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/M...tro/page5.html