Executing a procedure from the cammand line

[Bruce A. Julseth]

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

[s a n j a y]

Re: Executing a procedure from the cammand line

mysql -u USERNAME -p < myproc.sql

sanjay


"Bruce A. Julseth" <bruceaj@attglo bal.net> wrote in message
news:3f8b58f8_3 @news1.prserv.n et...
| 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
|
|

[Bruce A. Julseth]

Re: Executing a procedure from the cammand line

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@somewh ere.com> wrote in message
news:ujJib.1683 $8x2.879303@new ssrv26.news.pro digy.com...[color=blue][color=green]
> >[/color]
> sanjay
>
>
> "Bruce A. Julseth" <bruceaj@attglo bal.net> wrote in message
> news:3f8b58f8_3 @news1.prserv.n et...
> | 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]

[s a n j a y]

Re: Executing a procedure from the cammand line

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@attglo bal.net> wrote in message
news:3f8b6c68_3 @news1.prserv.n et...
| 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@somewh ere.com> wrote in message
| news:ujJib.1683 $8x2.879303@new ssrv26.news.pro digy.com...
| > >
| > sanjay
| >
| >
| > "Bruce A. Julseth" <bruceaj@attglo bal.net> wrote in message
| > news:3f8b58f8_3 @news1.prserv.n et...
| > | 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
| > |
| > |
| >
| >
|
|

[Bruce A. Julseth]

Re: Executing a procedure from the cammand line

Thank you..

Bruce

"s a n j a y" <someone@somewh ere.com> wrote in message
news:hOLib.1731 $8x2.918746@new ssrv26.news.pro digy.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@attglo bal.net> wrote in message
> news:3f8b6c68_3 @news1.prserv.n et...
> | 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@somewh ere.com> wrote in message
> | news:ujJib.1683 $8x2.879303@new ssrv26.news.pro digy.com...
> | > >
> | > sanjay
> | >
> | >
> | > "Bruce A. Julseth" <bruceaj@attglo bal.net> wrote in message
> | > news:3f8b58f8_3 @news1.prserv.n et...
> | > | 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]