Is
mysql -u USERNAME -p < myproc.sql
the only way.
If so, then if I have two procs to execute, I would execute one of them,
then I would have to "quit" and login a second time.
I was trying to avoid this.. I was hoping I could:
Login...
C:>mysql -u abc -p
Execute the two procs from the command line
mysql>Something MyProc1.sql;
mysql>Something MyProc2.sql;
Thanks....
Bruce
"s a n j a y" <so*****@somewhere.com> wrote in message
news:uj*******************@newssrv26.news.prodigy. com...
sanjay
"Bruce A. Julseth" <br*****@attglobal.net> wrote in message
news:3f********@news1.prserv.net...
| I have a SQL command procedure, myproc.sql, containing sql statements.
After
| I login to MySQL, how do I execute this procedure?
|
| mysql> ?????? what goes here???
|
| Thanks...
|
| Bruce
|
|