List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:April 6 2001 8:48pm
Subject:Re: Any way to pass variables into a SQL script???
View as plain text  
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 <mysql-thread70810@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thread
Any way to pass variables into a SQL script???Sandy Lewis6 Apr
  • Re: Any way to pass variables into a SQL script???Gerald Clark6 Apr