Since MySQL does not have a scripting language, you will have to use
something else.
You could use bourne shell scripts with variable substitution for batch
processes.
You could write scripts in perl, PHP, or python.
They all support variables and parameters.
Sandy Lewis wrote:
>
> I'm hoping someone can answer my question. I'm trying to pass variables
> into
> my sql script using mySQL and I can't seem to find how to do this.
>
> What I'm looking for is the mySQL eqivalent to ORACLE's
>
> myscript.sql date time
>
> where in the myscript.sql date and time are set as &1 and &2
>
> Can this be done using mySQL??
>
> Thanks for any help.
>
> Sandy Lewis
> Avant!
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
