title: Initialize a user-defined variable through mysql console parameters
body: <p>I would like to pass a value of a user-defined parameter to mysql console and use it as following:</p>
  
  <p><strong>example.sql</strong>:</p>
  
  <pre><code>    SELECT (@somevar + 1) as my_sum;
  </code></pre>
  
  <p><strong>usage example</strong>:</p>
  
  <pre><code>C:&gt;bin\mysql -utest -p --xml **{somehow @somevar:=100}** &lt; example.sql
  &lt;?xml version="1.0"?&gt;
  &lt;resultset statement="SELECT (@somevar + 1) as my_sum"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;
      &lt;row&gt;
          &lt;field name="my_sum" xsi:nil="true" /&gt;
      &lt;/row&gt;
  &lt;/resultset&gt;
  </code></pre>
  
  <p>Is it possible?</p>