Re: Scripts with arguments

2003-08-29 Thread Roger Baklund
* Enrique Andreu > Hello, I think I have explained bad. I want to pass > the arguments to the sql script. > The argument is for the sql script. > > For example: > myscript.sql should be: > GRANT ALL PRIVILEGES ON *.* TO &1@'%' > where &1 would be parameter 1 > > I want to do something like that: >

RE: Scripts with arguments

2003-08-29 Thread Enrique Andreu
Hello, I think I have explained bad. I want to pass the arguments to the sql script. The argument is for the sql script. For example: myscript.sql should be: GRANT ALL PRIVILEGES ON *.* TO &1@'%' where &1 would be parameter 1 I want to do something like that: dos>mysql mysql -u root -p < myscript

RE: Scripts with arguments

2003-08-29 Thread csebe
If it's going to be a simple batch file then use %1, %2, ... inside the script to get the parameters passed to it. Or better install & use a real scripting language like perl. ;-) Lian Sebe, M.Sc. Freelance Analyst-Programmer www.programEz.net > -Original Message- > From: Enrique Andreu