Bash: query MySQL and store result in an array

Simple bash example to store the output of a MySQL query in an array:

dbquery=$(mysql -u username -p password -e "use table; select field from table;")
array=( $( for i in $dbquery ; do echo $i ; done ) )

you can check the contents of your new array with:

echo ${array[@]}

Now that you have a nice array, you can do things like this:

for i in ${array[@]}
do echo $i

or, more sophisticated:

cnt=${#array[@]}
for (( i=0 ; i<cnt ; i++ ))
do echo "Record No. $i: ${array[$i]}"
done

simple, but effective !

Comments

[Jesus Guifarro]

one simple way is

dbquery=($(mysql -u username -p password -e "use table; select field from table;"))

now $dbquery is an array with the query values

[bocian85]

thank you very much

[Bui]

Thankyou, very simple and work!