title: store mysql query information chef
body: <p>I am trying to query my mysql database. I am using the <code>database</code> cookbook and can setup a connection with my database. I trying to query my database for information so now the question is how do I store than information so I can access it in another resource. Where do the results of the query get stored? This is my recipe:</p>
  
  <pre><code>mysql_database "Get admin users" do
      connection mysql_connection_info
      sql "Select * from #{table_name}"
      action :query
  end
  </code></pre>
  
  <p>Thanks in advance</p>