On Fri, Sep 12, 2008 at 5:26 PM, Roan Kattouw roan.kattouw@home.nl wrote:
(Come to think of it: you might wanna name your indices so they can be FORCE INDEXed if necessary.)
Indexes are named after their first column, by default. If there's a conflict, MySQL appends _2, _3, etc. (or maybe it starts at _1, I can't recall).