What’s the difference between using INDEX vs KEY in MySQL?

by

There’s no difference. They are synonyms.

From the CREATE TABLE manual entry:

KEY is normally a synonym for INDEX. The key attribute PRIMARY KEY can
also be specified as just KEY when given in a column definition. This was
implemented for compatibility with other database systems.

More Related Contents:

  1. Differences between INDEX, PRIMARY, UNIQUE, FULLTEXT in MySQL?
  2. Is the primary key automatically indexed in MySQL?
  3. How do I add indexes to MySQL tables?
  4. When should I use a composite index?
  5. How do MySQL indexes work?
  6. Best type of indexing when there is LIKE clause [duplicate]
  7. What does the KEY keyword mean?
  8. Difference between Key, Primary Key, Unique Key and Index in MySQL
  9. MySQL indexes – what are the best practices?
  10. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  11. How to see indexes for a database or table in MySQL?
  12. Speeding up row counting in MySQL
  13. SQL keys, MUL vs PRI vs UNI
  14. MySQL varchar index length
  15. How do I get MySQL to use an INDEX for view query?
  16. DOs and DONTs for Indexes [closed]
  17. MySQL performance: multiple tables vs. index on single table and partitions
  18. Mysql covering vs composite vs column index
  19. Is there any performance gain in indexing a boolean field?
  20. Does Order of Fields of Multi-Column Index in MySQL Matter
  21. MySQL load data infile – acceleration?
  22. Create an index on a huge MySQL production table without table locking
  23. MySQL Integer vs DateTime index
  24. Can MySQL use multiple indexes for a single query?
  25. How to fix MySql: index column size too large (Laravel migrate)
  26. MySQL optimizing INSERT speed being slowed down because of indices
  27. Would it help to add index to BIGINT column in MySQL?
  28. MySQL: how to index an “OR” clause
  29. Mysql performance on 6 million row table
  30. Duplicate entry for key ‘group_key’

Leave a Comment