Query MySQL in Bash return multiple results
How put the following mysql results into an array?
USER=`mysql -h host --user=myuser --password=mypass MYDB -e "SELECT UserID FROM Users WHERE HireDate > $tDate;"`
while [ ... ]; do
$users = "$USER;"
Basically trying to concatenate it into a string delimited by ";"
Now once I get the array how do I list it into a log file
cat >> /home/me/users/users.log << EOF
I know the syntax is ugly but I really have no clue, well very little clue.
And thanks for your help!