Help with sql file

[Bugs]

Hi, I'm trying to create a sql file that you can query from a location on your computer. I want to be able to add fields to an already created table.

For example:

If A table is already created with fields 1,2, and 3, how do I insert fields 4 and 5?

I know how to manually do this, throught myphpadmin, but I'm trying to zip up a hackmod for a program and I'm trying to make it as simple as possible for the user to install it.

I don't the code. I've done some reading, but I think CREATE only creates a new table and INSERT puts info into the fields that are already there.

Thanks in advance for help.

[Xnuiem]

ALTER is the SQL command you are looking for. Google against mysql.com for it and you will find the answers way better than I could explain them.