>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.

What if you put both commands into mCode just separated with chr(13)+chr(10) and execute them at once?