is it possible to pass parameters to sql scripts in mysql?
oracle provides it like this
> sqlplus scott/tiger @anyscript.sql param
then you can refer to the parameter as &1 in the script, eg.
select * from anytable where key_col = &1;
will be expanded to
select * from anytable where key_col = param;
is there any possibility to do so in mysql?