title: What happens if I drop a MySQL column without dropping its index first?
body: <p>With one of my MySQL tables, I dropped column <strong>col1</strong> before I drop it from a unique index (col0, col1, col2, col3) that contains it.</p>
  
  <p>Is it automatically taken care of by MySQL? It seems the unique index that was previously (col0, col1, col2, col3) was automatically changed to (col0, col2, col3) after I deleted the column col1.</p>
  
  <p>Is it going to be a problem or do I have to drop the unique index and re-create it as (col0, col2, col3)?</p>