title: only a string is returned in a mysql query in a bash script
body: <p>There's plenty of similar questions out there that seem to answer this, but it's not working for me.</p>
  
  <p>Here's mysql query in a bash script, the resultant row comes back as a string, not as an array.
  Am I missing something?</p>
  
  <pre><code>while read -a row;
    do
     echo "${row[0]}";
    done &lt; &lt;(mysql -u $dbuser -p$dbpass -N --database=$dbname --host=$dbhost --batch -se  "SELECT id, CONCAT(id, '_', filename) from photos" );
  }
  </code></pre>
  
  <p>This echoes <code>200    200_filename.jpg</code>.
  I would think it is supposed to echo <code>200</code>.<br>
  Echoing <code>${row[1]}</code> displays a blank line.</p>