On Fri, Sep 12, 2008 at 5:26 PM, Roan Kattouw <roan.kattouw(a)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).