title: MySQL: How to set maximum row property in table?
body: <p>I want to set that my table will only have 4 rows or 4 records. For this I've created a table using the following syntax:</p>
  
  <pre><code>CREATE TABLE `zero`.`table_limit` 
     `name` varchar(20) DEFAULT NULL
  )
  ENGINE=InnoDB DEFAULT CHARSET=latin1 MAX_ROWS=4
  </code></pre>
  
  <p>I think it is right still when I trying to insert more than 4 rows, it is not showing any error.</p>
  
  <p>Can any body tell me where i m doing mistake?</p>