Shulou(Shulou.com)06/02 Report--

This article mainly introduces the types of expressions supported by SQLite. It is very detailed and has a certain reference value. Friends who are interested must read it!

Expressions in SQLite

In the basic complete form of SELECT, we will see that almost all clauses use expressions. The following are the expression types supported by SQLite.

Expr binary-op expr | / / binary operator

Expr [NOT] like-op expr [ESCAPE expr] | / / LIKE operator, one of the matching patterns

Unary-op expr | / / unary operator

(expr) | / / parentheses

Column-name | / / column name

Table-name. Column-name | / / Table name. Column name

Database-name. Table-name. Column-name | / / database name. Table name. Column name

Literal-value | / / literal quantity

Parameter | / / difference form

Function-name (expr-list | *) | / / function

Expr ISNULL | / / handle null values

Expr NOTNULL | / / is not empty

Expr [NOT] BETWEEN expr AND expr | / / range

Expr [NOT] IN (value-list) | / / range

Expr [NOT] IN (select-statement) | / / range

Expr [NOT] IN [database-name.] Table-name | / / range

[EXISTS] (select-statement) | / / exist

CASE [expr] (WHEN expr THEN expr) + [ELSE expr] END | / / conditional result

CAST (expr AS type) / / conversion

The above is all the content of the article "what are the expression types supported by SQLite". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.