MySQL施用单列索引和多列索引

2013-07-08

MySQL使用单列索引和多列索引Select peopleid FROM people Where lastnameSullivan Select peopleid F

MySQL使用单列索引和多列索引
Select peopleid FROM people Where lastname='Sullivan'; Select peopleid FROM people Where age='17'; Select peopleid FROM people Where lastname='Sullivan' AND age='17';