sqlite

database; ?? ??? ??????

indexed

英['?ndekst] 　　美['?ndekst]

adj.

by

English [baa] US [baa]

prep.

SQLite ??? ?? ?? ???

??: "INDEXED BY index-name" ?? ?? ????? ?? ???? ??? ???? ???? ?????. ??? ?? index-name? ???? ??? ??? ??? ? ?? ?? SQLite ? ??? ?????. "NOT INDEXED" ?? ?? ???(UNIQUE ? PRIMARY KEY ?? ??? ?? ??? ??? ??? ??)? ???? ? ???? ???? ??? ?????. ??? "NOT INDEXED"? ?????? INTEGER PRIMARY KEY? ???? ??? ?? ? ????.

??: ????? DELETE, UPDATE ?? SELECT ?? ?? ??? ? ?? INDEXED BY ?? ?????.

SELECT|DELETE|UPDATE ??1, ??2...
INDEXED BY(index_name)
table_name
??(??);

SQLite ??? ?? ?? ?

表 COMPANY，我們將創(chuàng)建一個索引，并用它進(jìn)行 INDEXED BY 操作。

sqlite> CREATE INDEX salary_index ON COMPANY(salary);
sqlite>
現(xiàn)在使用 INDEXED BY 子句從表 COMPANY 中選擇數(shù)據(jù)，如下所示：

sqlite> SELECT * FROM COMPANY INDEXED BY salary_index WHERE salary > 5000;