MySql + Non interactive Login !
 

Hi ,

Is it possible to Non Interactively login into SQL server and run a query and get the result back for my shell script to interpret ?

I want to write a script that a script which non interactively connects to my PL-SQL server ( The script resides on the same server .... not a remote server!) and run a query .

Can i redirect the query to my command prompt shell ?

Any help will be appreciated.

Regards,
Xanthium.

:smash:

is this about MySQL or Oracle?

You subject says MySQL, but the body of the message mentions PL-SQL, which I believe is oracle.

At any rate mysql can.

QUERY_RETURN=`echo "use user_database; select * from user;" | mysql --user=admin --password='secret'`

Its Oracle!
 

Hi Kervin,

Thanks for the reply.

Sorry it is Oracle. Since iam into network administration i didnt bother to see the differance between oracle and mysql! it was one and the same for me ( SQL afterall!)

Will it work with Oracle as well ?

Regards,
Xanthium.