题解 | #针对上面的salaries表emp_no字段创建索引idx_emp_no#
针对上面的salaries表emp_no字段创建索引idx_emp_no
http://www.nowcoder.com/practice/f9fa9dc1a1fc4130b08e26c22c7a1e5f
sqlite的强制索引是indexed by ,mysql的强制索引是force index(column) MySQL： select * form salaries force index(idx_emp_no) where emp_no=10005
sqlite: select * from salaries indexed by idx_emp_no where emp_no=10005