title: Store mysql query output into a shell variable
body: <p>I need a variable to hold results retrieved from the database. So far this is basically what I'm trying with no success.</p>
  
  <pre><code>myvariable=$(mysql database -u $user -p $password | SELECT A, B, C FROM table_a)
  </code></pre>
  
  <p>My understanding of bash commands is not very good as you can see.</p>