题解 | #针对上面的salaries表emp_no字段创建索引idx_emp_no#
针对上面的salaries表emp_no字段创建索引idx_emp_no
http://www.nowcoder.com/practice/f9fa9dc1a1fc4130b08e26c22c7a1e5f
sqlite:
select *
from salaries
indexed by idx_emp_no
where emp_no=10005
mysql: change "indexed by" to "force index + ()"