Assigning query result into a variable/file

swathikumar · 05-25-2011, 09:14 AM

Hi
I am connecting to MySQL DataBase using shellscript and writing a select statement like
select attachmentid from attachments where pageid=10175

I want to store the output of the select statement into a shellvariable or a file

How can i do it using shellscript.

Please guide me.

grail · 05-25-2011, 10:53 AM

Use $() and place your command in between to assign to a variable or > to redirect output to a file.

chrism01 · 05-25-2011, 07:28 PM

Useful shell links
http://rute.2038bug.com/index.html.gz
http://tldp.org/LDP/Bash-Beginners-G...tml/index.html
http://www.tldp.org/LDP/abs/html/

swathikumar · 05-26-2011, 01:38 AM

Thanks All,

I got the solution for this using like

mysql -h $host_name -u $username -p$password -D $db -e "select * from spaces where SPACENAME='AAAT Rollout'" > /Users/Desktop/test11

change the permission of the file chmod 757 filename

grail · 05-26-2011, 02:33 AM

Well I am not sure why you would make it world executable but not group, however, glad you found a solution.
Please mark as SOLVED.