title: Limit integer value for mysql's column
body: <p>I am about to  create a table using</p>
  
  <pre><code>CREATE TABLE clients
  (
  empno     INTEGER     NOT NULL DEFAULT 7654 
  cname     VARCHAR(20) NOT NULL
  );
  </code></pre>
  
  <p>Now, I want the empno value to be between 7000-8000. If not it should be rejected. First method is to use CHECK which of course MYSQL is going to ignore. Second is to create a another table with acceptable values and use it as a foreign constraint or something like that. Creating a table with 1000 values is very inconvenient. There must be an easier way but I have no idea.</p>