title: I keep getting this mysql error code #1089
body: <pre><code>CREATE TABLE `movies`.`movie`
  ( `movie_id` INT(3) NULL AUTO_INCREMENT, `movie_name` VARCHAR(25) NULL,
    `movie_embedded_id` VARCHAR(50) NULL, `rating_no` INT(3) NULL,
    `movie_description` VARCHAR(50) NULL, PRIMARY KEY (`movie_id`(3))) ENGINE = InnoDB;
  </code></pre>
  
  <p>I keep getting this error:</p>
  
  <blockquote>
    <p>#1089 - Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't
    support unique prefix keys.</p>
  </blockquote>
  
  <p>but I've got no idea what it means, anyone have a clue? </p>