使用强制索引查询的语法为:
DELETE|SELECT|UPDATE
COLUMNS
FROM
TABLE_NAME
INDEXED BY index_name
WHERE
index_column = condition
则此题的答案为
SELECT
*
FROM
salaries
INDEXED BY idx_emp_no
WHERE emp_no = 10005
使用强制索引查询的语法为:
DELETE|SELECT|UPDATE
COLUMNS
FROM
TABLE_NAME
INDEXED BY index_name
WHERE
index_column = condition
则此题的答案为
SELECT
*
FROM
salaries
INDEXED BY idx_emp_no
WHERE emp_no = 10005