SHOW BUILTINS

SHOW BUILTINS is used to list all supported builtin functions in TiDB.

Synopsis

ShowBuiltinsStmt
SHOWBUILTINS

Examples

SHOW BUILTINS;
+-----------------------------+ | Supported_builtin_functions | +-----------------------------+ | abs | | acos | | adddate | | addtime | | aes_decrypt | | aes_encrypt | | and | | any_value | | ascii | | asin | | atan | | atan2 | | benchmark | | bin | | bit_count | | bit_length | | bitand | | bitneg | | bitor | | bitxor | | case | | ceil | | ceiling | | char_func | | char_length | | character_length | | charset | | coalesce | | coercibility | | collation | | compress | | concat | | concat_ws | | connection_id | | conv | | convert | | convert_tz | | cos | | cot | | crc32 | | curdate | | current_date | | current_role | | current_time | | current_timestamp | | current_user | | curtime | | database | | date | | date_add | | date_format | | date_sub | | datediff | | day | | dayname | | dayofmonth | | dayofweek | | dayofyear | | decode | | default_func | | degrees | | des_decrypt | | des_encrypt | | div | | elt | | encode | | encrypt | | eq | | exp | | export_set | | extract | | field | | find_in_set | | floor | | format | | format_bytes | | format_nano_time | | found_rows | | from_base64 | | from_days | | from_unixtime | | ge | | get_format | | get_lock | | getparam | | getvar | | greatest | | gt | | hex | | hour | | if | | ifnull | | in | | inet6_aton | | inet6_ntoa | | inet_aton | | inet_ntoa | | insert_func | | instr | | intdiv | | interval | | is_free_lock | | is_ipv4 | | is_ipv4_compat | | is_ipv4_mapped | | is_ipv6 | | is_used_lock | | isfalse | | isnull | | istrue | | json_array | | json_array_append | | json_array_insert | | json_contains | | json_contains_path | | json_depth | | json_extract | | json_insert | | json_keys | | json_length | | json_merge | | json_merge_patch | | json_merge_preserve | | json_object | | json_pretty | | json_quote | | json_remove | | json_replace | | json_search | | json_set | | json_storage_size | | json_type | | json_unquote | | json_valid | | last_day | | last_insert_id | | lastval | | lcase | | le | | least | | left | | leftshift | | length | | like | | ln | | load_file | | localtime | | localtimestamp | | locate | | log | | log10 | | log2 | | lower | | lpad | | lt | | ltrim | | make_set | | makedate | | maketime | | master_pos_wait | | md5 | | microsecond | | mid | | minus | | minute | | mod | | month | | monthname | | mul | | name_const | | ne | | nextval | | not | | now | | nulleq | | oct | | octet_length | | old_password | | or | | ord | | password_func | | period_add | | period_diff | | pi | | plus | | position | | pow | | power | | quarter | | quote | | radians | | rand | | random_bytes | | regexp | | release_all_locks | | release_lock | | repeat | | replace | | reverse | | right | | rightshift | | round | | row_count | | rpad | | rtrim | | schema | | sec_to_time | | second | | session_user | | setval | | setvar | | sha | | sha1 | | sha2 | | sign | | sin | | sleep | | sm3 | | space | | sqrt | | str_to_date | | strcmp | | subdate | | substr | | substring | | substring_index | | subtime | | sysdate | | system_user | | tan | | tidb_decode_key | | tidb_decode_plan | | tidb_is_ddl_owner | | tidb_parse_tso | | tidb_version | | time | | time_format | | time_to_sec | | timediff | | timestamp | | timestampadd | | timestampdiff | | to_base64 | | to_days | | to_seconds | | trim | | truncate | | ucase | | unaryminus | | uncompress | | uncompressed_length | | unhex | | unix_timestamp | | upper | | user | | utc_date | | utc_time | | utc_timestamp | | uuid | | uuid_short | | validate_password_strength | | version | | week | | weekday | | weekofyear | | weight_string | | xor | | year | | yearweek | +-----------------------------+ 268 rows in set (0.00 sec)

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.