假设我想查询一个基于多个WHERE子句的表。 SELECT * WHERE (line_type='section_intro' OR line_type='question') ORDER BY line_order"; SELECT * WHERE (line_order BETWEEN 0 AND 12)
AND
MySQL可以使用两个或多个索引搜索表行吗?我有一张有这些列的桌子:- type varchar(32)- id_bar intSELECT id_bar FROM relation WHERE type = 'qux' AND id_foo = 256
为这个表和这些搜索查询定义索引的正确方法是什么是在所有三列</