Catalog

1. Syntax Support
2. Operator
3. Built-in Function
   3.1 Type Conversion Function
   3.2 Aggregate Function
   3.3 String Function
   3.4 Mathematical Functions
   3.5 Date time Function
   3.6 Condition Function
4. appendix
   4.1 Date Format
   4.2 Keywords

Syntax Support

BLS supports basic SELECT query, and the specific query syntax is

SELECT 
    select_expr [, select_expr] ... 
    [FROM subquery [AS] table_id] 
    [WHERE where_condition] 
    [GROUP BY {col_name | expr}, ... ] 
    [HAVING where_condition] 
    [ORDER BY {col_name | expr} [ASC | DESC], ...] 
    [LIMIT [offset,] row_count] 

Among them, where_condition is a conditional expression whose execution result is a Boolean value. Don't write the FROM clause when you don't need a subquery.

Field names are case sensitive, and try to avoid using keyword. If keywords are used, add backquotes, for example: `action`.

Operator

Unary prefix operation

Binary operation

Relational operations

Logic operation

Built-in Function

Type Conversion Function

Aggregate Function

String Function

Mathematical Function

Date and Time Functions

Condition Function

Appendix

Date Format

Date_format supported by time function

Keyword

#

_binary
_utf8mb4

A - F

accessible action add against all alter analyze and as asc asensitive auto_increment before begin between bigint binary bit blob bool boolean both by call cascade case cast change char character charset check collate collation column columns comment commit committed condition constraint continue convert create cross current_date current_time current_timestamp current_user cursor database databases date datetime day_hour day_microsecond day_minute day_second dec decimal declare default delayed delete desc describe descriptor deterministic distinct distinctrow div double drop duplicate each else elseif enclosed end engines enum escape escaped exists exit expansion explain false fetch fields float float4 float8 flush for force foreign from full fulltext

G - N

generated geometry geometrycollection get global grant group group_concat having high_priority hour_microsecond hour_minute hour_second if ignore in index infile inner inout insensitive insert int int1 int2 int3 int4 int8 integer interval into io_after_gtids is isolation iterate join json key key_block_size keys kill language last_insert_id leading leave left less level like limit linear lines linestring load localtime localtimestamp lock long longblob longtext loop low_priority master_bind match maxvalue mediumblob mediumint mediumtext middleint minute_microsecond minute_second mod mode modifies multilinestring multipoint multipolygon names natural nchar next no no_write_to_binlog not null numeric

O - S

off offset on only optimize optimizer_costs option optionally or order out outer outfile partition plugins point polygon precision primary procedure processlist query read read_write reads real references regexp release rename reorganize repair repeat repeatable replace require resignal restrict return revoke right rlike rollback schema schemas second_microsecond select sensitive separator serializable session set share show signal signed smallint spatial specific sql sql_big_result sql_cache sql_calc_found_rows sql_no_cache sql_small_result sqlexception sqlstate sqlwarning ssl start starting status stored straight_join stream string substr substring

T - Z

table tables terminated text than then time timestamp timestampadd timestampdiff tinyblob tinyint tinytext to trailing transaction trigger true truncate uncommitted undo union unique unlock unsigned update usage use using utc_date utc_time utc_timestamp values varbinary varchar varcharacter variables varying view vindex vindexes virtual vitess_keyspaces vitess_shards vitess_tablets vitess_target vschema vschema_tables warnings when where while with write xor year year_month zerofill