I keep getting this mysql error code #1089

by

With the part 

PRIMARY KEY (`movie_id`(3))

you are telling mysql to create a sub part key* on the first 3 Bytes of movie id. This only works for string types.

You need to use 

PRIMARY KEY (`movie_id`)

without providing a length.

*Is this sure the query resulting in the error? Never saw that on a primary key, its used for indexes.

More Related Contents:

  1. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  2. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  3. Count the occurrences of DISTINCT values
  4. Codeigniter – multiple database connections
  5. Column count doesn’t match value count at row 1
  6. How to add levenshtein function in mysql?
  7. How to search JSON data in MySQL?
  8. MySQL > Table doesn’t exist. But it does (or it should)
  9. How do I modify a MySQL column to allow NULL?
  10. Connect to mysql in a docker container from the host
  11. Is there ANY_VALUE capability for mysql 5.6?
  12. Set NOW() as Default Value for datetime datatype?
  13. MySQL update CASE WHEN/THEN/ELSE [duplicate]
  14. SQL DELETE with JOIN another table for WHERE condition
  15. How to connect to a MySQL Data Source in Visual Studio
  16. DOs and DONTs for Indexes [closed]
  17. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  18. MySQL: #1075 – Incorrect table definition; autoincrement vs another key?
  19. How can I implement single table inheritance using Laravel’s Eloquent?
  20. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  21. Integrity constraint violation: 1452 Cannot add or update a child row:
  22. How to change the mysql root password
  23. How can I set autoincrement format to 0001 in MySQL?
  24. Using DISTINCT and COUNT together in a MySQL Query
  25. Continue SQL query even on errors in MySQL workbench
  26. Which DATATYPE is better to use TEXT or VARCHAR?
  27. How to generate a UUIDv4 in MySQL?
  28. Unserialize through query at database level itself
  29. Detecting utf8 broken characters in MySQL
  30. django cannot connect mysql in docker-compose

Leave a Comment