SELECT * FROM COMPANY INDEXED BY salary_index WHERE salary > 5000;
INDEXED BY salary_index
这个才是sqlite的用法
参考:https://www.runoob.com/sqlite/sqlite-indexed-by.html
【说明】:本文章由站长整理发布,文章内容不代表本站观点,如文中有侵权行为,请与本站客服联系(QQ:254677821)!
SELECT * FROM COMPANY INDEXED BY salary_index WHERE salary > 5000;
INDEXED BY salary_index
这个才是sqlite的用法
参考:https://www.runoob.com/sqlite/sqlite-indexed-by.html