Question: ```
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;

```

I keep getting this error:

> 
> #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.
> 
> 
> 

but I've got no idea what it means, anyone have a clue?

Answer: 
after selecting PRIMARY KEY when you create table, don't input any value in pop dialog
You can also get this error when creating an index if you specify a prefix length that is longer than the length of the actual column. If you tried to create an index containing `someColumn(20)` but in the table *someColumn* is `VARCHAR(15)`, then this error will occur.