title: MySql command line: execute two queries at once?
body: <p>I am using the MySql command tool to query a database from inside a Ruby script I wrote. However the need has arisen for a query that creates a temporary table, then in another query I need to perform a join on the temporary table. The only problem is every time I invoke <code>mysql -h &lt;host&gt; -r &lt;username&gt; -D &lt;database&gt; -e "QUERY"</code> I get a new transaction, so when I am trying to perform my join, the temporary table doesn't exist anymore. </p>
  
  <p>Is there anyway to do execute two separate queries in <strong>one</strong> invocation of the mysql command line tool??</p>
  
  <p>Something like:
  <code>mysql -h &lt;host&gt; -r &lt;username&gt; -D &lt;database&gt; -e "QUERY1" -e "QUERY2"</code></p>
  
  <p>Or is there some alternative way to store my queries? like in a text file or something?</p>
  
  <p>Thanks</p>