Re: Passing variable to SQL script

[Ravi Kotichintala]

Kay's solution is brilliant (just note that it did not work for me without putting a semicolon at the end of 'source run.sql;'). This however is the fountainhead idea from which heavy automation can be derived. Lot of us are used to massive Oracle script based installers that setup core data for customizing an app.

Linux being the most preferred platform for automation and scripting - here's a simple example of how to extend this solution to that affect:

SHELL SCRIPT
. . . .
echo Installing Data
mysql -e "set @firstname:=$1; set @lastname=$2; source run.sql;"

SQL RUN.SQL
insert into customers (firstname, lastname) values (@firstname, @lastname)

Nothing phenomenal but the potential is obvious. Automation with scripts, integration directly with the UI . . . list goes on