I am pretty sure that the delimiter for a new line in mySql is a semicolon. The line below should work. I am also wondering if you couldn't do the same thing using sqlexec().

mcode1="use mydatabase;alter table customer ADD email_add VARCHAR(45);" 
?sqlexec(mscon,mcode1,'resultcur') 

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