What does the KEY keyword mean?

by

Quoting from create-table – indexes andkeys

{INDEX|KEY}

So KEY is usually an INDEX

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. How do I add indexes to MySQL tables?
  2. Differences between INDEX, PRIMARY, UNIQUE, FULLTEXT in MySQL?
  3. Is it possible to have function-based index in MySQL?
  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. Does MySQL index foreign key columns automatically?
  8. Is the primary key automatically indexed in MySQL?
  9. Difference between Key, Primary Key, Unique Key and Index in MySQL
  10. MySQL indexes – what are the best practices?
  11. How to see indexes for a database or table in MySQL?
  12. Speeding up row counting in MySQL
  13. What is cardinality in MySQL?
  14. What’s the difference between using INDEX vs KEY in MySQL?
  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 distinction between e and é (e acute) – UNIQUE index
  27. MySQL optimizing INSERT speed being slowed down because of indices
  28. Would it help to add index to BIGINT column in MySQL?
  29. MySQL: how to index an “OR” clause
  30. Mysql performance on 6 million row table

Leave a Comment