sqlite
; ?? ??? ??????
English [?nd, ?n,?nd]
conj; orEnglish [?r]
conj. Or; or, else; left or rightprep.
SQLite AND/OR ?? ???
??: AND ???? ???? SQL ?? WHERE ?? ?? ??? ??? ? ????. AND ???? ???? ?? ??? true? ???? ?? ??? true? ???. ?? ??, [??1] AND [??2]? ??1? ??2? ?? ?? ???? ????. OR ???? SQL ?? WHERE ??? ?? ??? ???? ??? ?????. OR ???? ??? ?? ?? ? ???? true?? ?? ??? true? ???. ?? ??, [??1] OR [??2]? ??1?? ??2 ? ??? ?? ??? ????.
??: ??AND:SELECT ?1, ?2, ?N FROM ???_?? WHERE [??1] AND [??2]...AND [??N]
OR: SELECT ?1, ?2, ?N FROM ???_?? WHERE [??1] OR [ ??2]...OR [??N]
SQLite AND/OR ?? ?
AND實例： COMPANY 表 ID NAME AGE ADDRESS SALARY ---------- ---------- ---------- ---------- ---------- 1 Paul 32 California 20000.0 2 Allen 25 Texas 15000.0 3 Teddy 23 Norway 20000.0 4 Mark 25 Rich-Mond 65000.0 5 David 27 Texas 85000.0 6 Kim 22 South-Hall 45000.0 7 James 24 Houston 10000.0 下面的 SELECT 語句列出了 AGE 大于等于 25 且工資大于等于 65000.00 的所有記錄： sqlite> SELECT * FROM COMPANY WHERE AGE >= 25 AND SALARY >= 65000; ID NAME AGE ADDRESS SALARY ---------- ---------- ---------- ---------- ---------- 4 Mark 25 Rich-Mond 65000.0 5 David 27 Texas 85000.0 OR實例： COMPANY 表 ID NAME AGE ADDRESS SALARY ---------- ---------- ---------- ---------- ---------- 1 Paul 32 California 20000.0 2 Allen 25 Texas 15000.0 3 Teddy 23 Norway 20000.0 4 Mark 25 Rich-Mond 65000.0 5 David 27 Texas 85000.0 6 Kim 22 South-Hall 45000.0 7 James 24 Houston 10000.0 下面的 SELECT 語句列出了 AGE 大于等于 25 或工資大于等于 65000.00 的所有記錄： sqlite> SELECT * FROM COMPANY WHERE AGE >= 25 OR SALARY >= 65000; ID NAME AGE ADDRESS SALARY ---------- ---------- ---------- ---------- ---------- 1 Paul 32 California 20000.0 2 Allen 25 Texas 15000.0 4 Mark 25 Rich-Mond 65000.0 5 David 27 Texas 85000.0