What is wrong with my SQL here? #1089 – Incorrect prefix key

by

In your PRIMARY KEY definition you’ve used (id(11)), which defines a prefix key – i.e. the first 11 characters only should be used to create an index. Prefix keys are only valid for CHAR, VARCHAR, BINARY and VARBINARY types and your id field is an int, hence the error.

Use PRIMARY KEY (id) instead and you should be fine.

MySQL reference here and read from paragraph 4.

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. SQL Print the name of all Employees together with the name of their supervisor
  3. MySQL – Rows to Columns
  4. ROW_NUMBER() in MySQL
  5. multiple query same table but in different columns mysql
  6. How can I make SQL case sensitive string comparison on MySQL?
  7. How can I temporarily disable a foreign key constraint in MySQL?
  8. How to do a batch insert in MySQL
  9. MySQL offset infinite rows
  10. Ordering by the order of values in a SQL IN() clause
  11. Creating a “Numbers Table” in MySQL
  12. SQL Selecting from two Tables with inner join and limit [duplicate]
  13. MySQL Group by SUM
  14. In SQL, how to select the top 2 rows for each group
  15. Mysql query to dynamically convert rows to columns on the basis of two columns
  16. MySQL Error 1264: out of range value for column
  17. mysql trigger stored trigger is already used by statement which invoked stored trigger
  18. Special Characters in MySQL Table Name
  19. MySQL: How do I join same table multiple times?
  20. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  21. What is the difference between the backtick and the square bracket in SQL statements?
  22. How to insert a file in MySQL database?
  23. What does SQL Select symbol || mean?
  24. Empty IN clause parameter list in MySQL
  25. creating a random number using MYSQL
  26. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  27. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  28. What happens when I exhaust a bigint generated key? How to handle it?
  29. MySQL update statement to store ranking positions
  30. is there a length limit to group_concat or another reason why it would not work on a text field

Leave a Comment