Aryeh Gregor schreef:
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).
Still, it would be cleaner and clearer to explicitly name them, like we do in tables.sql
Roan Kattouw (Catrope)