How can I read mysql data in a variable

[bram]

Dear ,

I have search a lot about a way to read data from a mysql database in a bash variable but find no solution, i hope someone can help me with this?
i connect in bash to mysql:

mysql -uroot -pPassword -DtblTable -e "select groeps from yblTable;"

I need the result of this select query in a variable groeps($groeps).

kind regards,

bram

[jemy]

hi,

is that right?
You are looking for a bash script, which takes a variable out of mysql...
Something like that, maybe:

#!/bin/sh
# database test

test1=(`mysql -uroot -pPassword -DtblTable -e "select groeps from yblTable;"``)
echo
echo "${test1[1]}"
echo

[bram]

Thanks Jamy!

It works!

kind regards,

bram