title: Limit number of positions after decimal point in MariaDB
body: <p>I am currently making a small MariaDB database and ran into the following problem:
  I want to save a floatingpoint number with only 2 poistions after the decimal point but everything before the decimal point should be unaffected.</p>
  
  <p>For example: 1.11; 56789.12; 9999.00; 999999999999.01 etc.</p>
  
  <p>I have done some research and this is what I am using right now:</p>
  
  <pre><code>CREATE TABLE mytable (
      mynumber DOUBLE(10, 2)
  )
  </code></pre>
  
  <p>The problem with this solution is that I also have to limit the number of positions before the decimal point, what I don't want to do.</p>
  
  <p>So is there a possibility to limit the number of positions after the decimal point without affecting the positions before the decimal point or is there a "default number" I can use for the positions before the decimal point?</p>