SHOW FUNCTIONS
引入或更新: v1.2.315
列出当前支持的内置标量和聚合函数。
另请参阅: system.functions
语法
SHOW FUNCTIONS [LIKE '<pattern>' | WHERE <expr>] | [LIMIT <limit>]
示例
SHOW FUNCTIONS;
+-------------------------+--------------+---------------------------+
| name | is_aggregate | description |
+-------------------------+--------------+---------------------------+
| != | 0 | |
| % | 0 | |
| * | 0 | |
| + | 0 | |
| - | 0 | |
| / | 0 | |
| < | 0 | |
| <= | 0 | |
| <> | 0 | |
| = | 0 | |
+-------------------------+--------------+---------------------------+
显示以 "today" 开头的函数:
SHOW FUNCTIONS LIKE 'today%';
+--------------+--------------+-------------+
| name | is_aggregate | description |
+--------------+--------------+-------------+
| today | 0 | |
| todayofmonth | 0 | |
| todayofweek | 0 | |
| todayofyear | 0 | |
+--------------+--------------+-------------+
使用 WHERE 显示以 "today" 开头的函数:
SHOW FUNCTIONS WHERE name LIKE 'today%';
+--------------+--------------+-------------+
| name | is_aggregate | description |
+--------------+--------------+-------------+
| today | 0 | |
| todayofmonth | 0 | |
| todayofweek | 0 | |
| todayofyear | 0 | |
+--------------+--------------+-------------+
