Grabbing result of sql command

hern14 · #1 (**permalink**) 07-23-2008

Hi guys,

Is there a way a script can run an SQL statement and dump the results into a variable which can then be used later in the script?

Thanks.

Ikon · #2 (**permalink**) 07-23-2008

Try this:

Code:

TABLE_NAME=sometable
USER_NAME=someuser
IP_ADDR=localhost
PASSWORD=somepassword

somevar=`echo "select * from <table_name> where <condition>" | mysql -h $IP_ADDR -u $USER_NAME -p$PASSWD $TABLE_NAME `

echo $somevar

hern14 · #3 (**permalink**) 07-23-2008

Thanks for the help..

I get the following error:

mysql: not found.

I am using Unix on AIX platform, bin/sh script, and DB2 database.

Ikon · #4 (**permalink**) 07-23-2008

That was for a mysql database.

Try to Google: db2 shell query

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
storing result of a command in variable	eltinator	Shell Programming and Scripting	1	04-17-2008 08:09 PM
echo command result	umen	UNIX for Dummies Questions & Answers	2	11-10-2005 08:39 AM
FTP command result	nymus7	IP Networking	1	08-08-2005 05:01 PM
find command not returning any result	rraajjiibb	UNIX for Advanced & Expert Users	4	07-23-2004 05:05 PM
Interpretting the result of TOP command	sanjay92	UNIX for Dummies Questions & Answers	2	09-21-2001 05:50 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by