How to convert MySQL query output in array in shell scripting?

Question

I am storing output of MySQL query in a varible using shell scripting. The output of SQL query is in multiple rows. When I checked the count of the variable (which I think is an array), it is giving 1. My code snippet is as follows:

sessionLogin=`mysql  -ugtsdbadmin -pgtsdbadmin -h$MYSQL_HOST -P$MYSQLPORT CMDB -e " select distinct SessionID  div 100000 as 'MemberID' from SessionLogin where ClientIPAddr  like '10.104%' and LoginTimestamp > 1426291200000000000 order by 1;"`

echo "${#sessionLogin[@]}"

How can I store the MySQL query output in an array in shell scripting?

Friedrich 'Fred' Clausen · Accepted Answer · 2015-03-26 01:28:11Z

5

You can loop over the output from mysql and append to an existing array. For example, in Bash 3.1+, a while loop with process substitution is one way to do it (please replace the mysql parameters with your actual command)

output=()
while read -r output_line; do
    output+=("$output_line")
done < <(mysql -u user -ppass -hhost DB -e "query")
echo "There are ${#output[@]} lines returned"

Also take a look at the always excellent BashFaq

answered Mar 26, 2015 at 1:28

Friedrich 'Fred' Clausen

3,5339 gold badges42 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to convert MySQL query output in array in shell scripting?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related