What happens if I drop a MySQL column without dropping its index first?

by

According to the MySQL 5.1 Reference Manual:

If columns are dropped from a table,
the columns are also removed from any
index of which they are a part. If all
columns that make up an index are
dropped, the index is dropped as well.
If you use CHANGE or MODIFY to shorten
a column for which an index exists on
the column, and the resulting column
length is less than the index length,
MySQL shortens the index
automatically.

Related Contents:

  1. Differences between INDEX, PRIMARY, UNIQUE, FULLTEXT in MySQL?
  2. How to see indexes for a database or table in MySQL?
  3. How do I add indexes to MySQL tables?
  4. How do MySQL indexes work?
  5. Does MySQL index foreign key columns automatically?
  6. Is the primary key automatically indexed in MySQL?
  7. MySQL indexes – what are the best practices?
  8. Is it a good idea to index datetime field in mysql?
  9. What does the KEY keyword mean?
  10. When should I use a composite index?
  11. How to drop unique in MySQL?
  12. Is there any performance gain in indexing a boolean field?
  13. Create an index on a huge MySQL production table without table locking
  14. MySQL – why not index every field?
  15. Does a UNIQUE constraint automatically create an INDEX on the field(s)?
  16. How to check if an index exists on a table field in MySQL
  17. What is cardinality in MySQL?
  18. MySQL cannot create foreign key constraint
  19. With MySQL, how can I generate a column containing the record index in a table?
  20. With MySQL, how long does an “ALTER TABLE … DISABLE KEYS;” statement last?
  21. Does Order of Fields of Multi-Column Index in MySQL Matter
  22. Creating an index on a timestamp to optimize query
  23. Does MySQL index NULL values?
  24. Understanding multiple column indexes in MySQL query
  25. Is it possible to have function-based index in MySQL?
  26. SQL: set existing column as Primary Key in MySQL
  27. How do I get MySQL to use an INDEX for view query?
  28. What is difference between primary index and secondary index exactly? [duplicate]
  29. Copy a MySQL table including indexes
  30. How can I add an INDEX with Doctrine 2 to a column without making it a primary key?
  31. MySQL 5.0 indexes – Unique vs Non Unique
  32. FORCE INDEX in MySQL – where do I put it?
  33. Does it make sense to use an index that will have a low cardinality?
  34. Handling very large data with mysql
  35. MySQL: unique field needs to be an index?
  36. MySQL Integer vs DateTime index
  37. Does Laravel’s “soft_delete” need index on MySQL?
  38. Speeding up row counting in MySQL
  39. Indexing a MySql TEXT column?
  40. How to drop this index in MySQL?
  41. MySQL – how long to create an index?
  42. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  43. Does index on Varchar make performance difference?
  44. How to hint the index to use in a MySQL select query?
  45. Do index names have to be unique across entire database in Mysql?
  46. How to disable index in innodb
  47. How to properly index a linking table for many-to-many connection in MySQL?
  48. MySQL indices and order
  49. Mysql covering vs composite vs column index
  50. MySQL performance: multiple tables vs. index on single table and partitions

Leave a Comment