Executing a procedure from the cammand line

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

mysql -u USERNAME -p < myproc.sql

sanjay


"Bruce A. Julseth" <bruceaj@attglobal.net> wrote in message
news:3f8b58f8_3@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
|
|

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" <someone@somewhere.com> wrote in message
news:ujJib.1683$8x2.879303@newssrv26.news.prodigy. com...[color=blue][color=green]
> >[/color]
> sanjay
>
>
> "Bruce A. Julseth" <bruceaj@attglobal.net> wrote in message
> news:3f8b58f8_3@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
> |
> |
>
>[/color]

I dont know how to do it after you go to mysql shell. But you dont relly
need to do that way. If multiple files is your problem, then you have two
options,

1. concatenate files manually and run as a single sql. or

2. do something like -
cat sql1.sql sql2.sql | mysql -u USERNAME -p

haven't tested second one, but should work.

sanjay




"Bruce A. Julseth" <bruceaj@attglobal.net> wrote in message
news:3f8b6c68_3@news1.prserv.net...
| 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" <someone@somewhere.com> wrote in message
| news:ujJib.1683$8x2.879303@newssrv26.news.prodigy. com...
| > >
| > sanjay
| >
| >
| > "Bruce A. Julseth" <bruceaj@attglobal.net> wrote in message
| > news:3f8b58f8_3@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
| > |
| > |
| >
| >
|
|

Thank you..

Bruce

"s a n j a y" <someone@somewhere.com> wrote in message
news:hOLib.1731$8x2.918746@newssrv26.news.prodigy. com...[color=blue]
> I dont know how to do it after you go to mysql shell. But you dont relly
> need to do that way. If multiple files is your problem, then you have two
> options,
>
> 1. concatenate files manually and run as a single sql. or
>
> 2. do something like -
> cat sql1.sql sql2.sql | mysql -u USERNAME -p
>
> haven't tested second one, but should work.
>
> sanjay
>
>
>
>
> "Bruce A. Julseth" <bruceaj@attglobal.net> wrote in message
> news:3f8b6c68_3@news1.prserv.net...
> | 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" <someone@somewhere.com> wrote in message
> | news:ujJib.1683$8x2.879303@newssrv26.news.prodigy. com...
> | > >
> | > sanjay
> | >
> | >
> | > "Bruce A. Julseth" <bruceaj@attglobal.net> wrote in message
> | > news:3f8b58f8_3@news1.prserv.net...
> | > | I have a SQL command procedure, myproc.sql, containing sql[/color]
statements.[color=blue]
> | > After
> | > | I login to MySQL, how do I execute this procedure?
> | > |
> | > | mysql> ?????? what goes here???
> | > |
> | > | Thanks...
> | > |
> | > | Bruce
> | > |
> | > |
> | >
> | >
> |
> |
>
>[/color]