I'm using VFP with MySQL database.

I want to modify the table, the original code:

C:\Program Files\MySQL\MySQL Server 5.1\bin\
mysql -umydata -pmypassword 
use mydatabase;
alter table customer ADD email_add VARCHAR(45);

in PRG:

lcOldDir=Fullpath(Curdir())
CD "C:\Program Files\MySQL\MySQL Server 5.1\bin\"
mcode1="use mydatabase;"
mcode2="alter table customer ADD email_add VARCHAR(45);"
RUN mysql -umydata -pmypassword -e %mcode1%
cd (lcOldDir)

I don't know how to put the two lines command.

any suggestion?

thanks for the help.