围观反面教材
[/Quote]
select sum(price)sPrice,sum(score)Score,name,address where age <30 and age>10 and cinemane in('55') group by name,address
这里的 name address price score age 都有索引
查询太牛B了。
[/Quote]
select sum(price)sPrice,sum(score)Score,name,address where age <30 and age>10 and cinemane in('55') group by name,address
这里的 name address price score age 都有索引
查询很简单
500多行不可能那么慢的,肯定是你处理有问题。
[/Quote]
select sum(price)sPrice,sum(score)Score,name,address where age <30 and age>10 and cinemane in('55') group by name,address
这里的 name address price score age 都有索引