2.1.4.2 OQL详细语法
由 superadmin 于 2020/08/29, 09:02 最后修改
Contents
OQL详细语法
使用BNF语句OQL语法描述如下:
query ::= select-query [UNION query] select-query ::= SELECT class-reference [class-joined] [WHERE expression] class-reference ::= name [AS name] class-joined ::= JOIN class-reference ON name.name = name.id name ::= string | `string` expression ::= scalar | expression operator expression | (expression) scalar ::= number | ‘string’ | “string” | column operator ::= AND | OR | = | <> | != | > | >= | < | <= | LIKE | NOT LIKE | MATCHES column ::= name | name.name
原文:https://www.itophub.io/wiki/page?id=2_6_0%3Aoql%3Aoql_grammar
OQL Grammar
The OQL grammar can be described as following using the BNF syntax:
query ::= select-query [UNION query] select-query ::= SELECT class-reference [class-joined] [WHERE expression] class-reference ::= name [AS name] class-joined ::= JOIN class-reference ON name.name = name.id name ::= string | `string` expression ::= scalar | expression operator expression | (expression) scalar ::= number | ‘string’ | “string” | column operator ::= AND | OR | = | <> | != | > | >= | < | <= | LIKE | NOT LIKE | MATCHES column ::= name | name.name