title: Give an int table column in MySQL a range of allowed values from 1 to 9
body: <p>I am new in MySQL and I was wondering if there is a way of giving a column a range of accepted values let's say from 1 to 9; I was trying the following but it does not work.</p>
  
  <pre><code>CREATE TABLE rooms (
      `rNumber` INT( 1 -9 ) NOT NULL AUTO_INCREMENT ,
      PRIMARY KEY ( `hNumber` )
  )
  </code></pre>
  
  <p>Any help is appreciated.</p>