SHOW INDEX FROM tablename;
ALTER TABLE tablename ADD INDEX indexname (column1, column2);
ALTER TABLE tablename ADD UNIQUE INDEX indexname (column1, column2);
ALTER TABLE tablename DROP INDEX indexname;
Read next
The Index Is Lying to You Againthauerbyi · 
First Context - Easily Find a Creator and Add Them to the Systemstarkerz · 
Learn Rust Series (#42) - Drop Order, the Drop Check & Leak Safetyscipio · 
When two stocks control 50% of your national stock index, a tech correction isn't just a pullback—it’s a systemic migration of capital."
willson28 ·
From @taegyunkim