title: MySQL - stored procedure set and round
body: <p>I need to write <a href="http://en.wikipedia.org/wiki/MySQL" rel="nofollow">MySQL</a> <code>set</code> and <code>round</code> in one line. That is, is there any option to write a stored procedure like this in MySQL?</p>
  
  <pre><code>SET x = ROUND'(Y,2);
  </code></pre>
  
  <p>I have also tied the method like this</p>
  
  <pre><code>DECLARE z INTEGER;
  DECLARE x FLOAT;
  SET z = y*100;
  SET x = z/100;
  </code></pre>
  
  <p>But it is also not working. Is there any way to round a variable in MySQL when we set the value to that variable?</p>