SHOW BUILTINS

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

Synopsis

ShowBuiltinsStmt:

ShowBuiltinsStmt

Examples

  1. SHOW BUILTINS;
  1. +-----------------------------+
  2. | Supported_builtin_functions |
  3. +-----------------------------+
  4. | abs |
  5. | acos |
  6. | adddate |
  7. | addtime |
  8. | aes_decrypt |
  9. | aes_encrypt |
  10. | and |
  11. | any_value |
  12. | ascii |
  13. | asin |
  14. | atan |
  15. | atan2 |
  16. | benchmark |
  17. | bin |
  18. | bit_count |
  19. | bit_length |
  20. | bitand |
  21. | bitneg |
  22. | bitor |
  23. | bitxor |
  24. | case |
  25. | ceil |
  26. | ceiling |
  27. | char_func |
  28. | char_length |
  29. | character_length |
  30. | charset |
  31. | coalesce |
  32. | coercibility |
  33. | collation |
  34. | compress |
  35. | concat |
  36. | concat_ws |
  37. | connection_id |
  38. | conv |
  39. | convert |
  40. | convert_tz |
  41. | cos |
  42. | cot |
  43. | crc32 |
  44. | curdate |
  45. | current_date |
  46. | current_role |
  47. | current_time |
  48. | current_timestamp |
  49. | current_user |
  50. | curtime |
  51. | database |
  52. | date |
  53. | date_add |
  54. | date_format |
  55. | date_sub |
  56. | datediff |
  57. | day |
  58. | dayname |
  59. | dayofmonth |
  60. | dayofweek |
  61. | dayofyear |
  62. | decode |
  63. | default_func |
  64. | degrees |
  65. | des_decrypt |
  66. | des_encrypt |
  67. | div |
  68. | elt |
  69. | encode |
  70. | encrypt |
  71. | eq |
  72. | exp |
  73. | export_set |
  74. | extract |
  75. | field |
  76. | find_in_set |
  77. | floor |
  78. | format |
  79. | format_bytes |
  80. | format_nano_time |
  81. | found_rows |
  82. | from_base64 |
  83. | from_days |
  84. | from_unixtime |
  85. | ge |
  86. | get_format |
  87. | get_lock |
  88. | getparam |
  89. | getvar |
  90. | greatest |
  91. | gt |
  92. | hex |
  93. | hour |
  94. | if |
  95. | ifnull |
  96. | in |
  97. | inet6_aton |
  98. | inet6_ntoa |
  99. | inet_aton |
  100. | inet_ntoa |
  101. | insert_func |
  102. | instr |
  103. | intdiv |
  104. | interval |
  105. | is_free_lock |
  106. | is_ipv4 |
  107. | is_ipv4_compat |
  108. | is_ipv4_mapped |
  109. | is_ipv6 |
  110. | is_used_lock |
  111. | isfalse |
  112. | isnull |
  113. | istrue |
  114. | json_array |
  115. | json_array_append |
  116. | json_array_insert |
  117. | json_contains |
  118. | json_contains_path |
  119. | json_depth |
  120. | json_extract |
  121. | json_insert |
  122. | json_keys |
  123. | json_length |
  124. | json_merge |
  125. | json_merge_patch |
  126. | json_merge_preserve |
  127. | json_object |
  128. | json_pretty |
  129. | json_quote |
  130. | json_remove |
  131. | json_replace |
  132. | json_search |
  133. | json_set |
  134. | json_storage_size |
  135. | json_type |
  136. | json_unquote |
  137. | json_valid |
  138. | last_day |
  139. | last_insert_id |
  140. | lastval |
  141. | lcase |
  142. | le |
  143. | least |
  144. | left |
  145. | leftshift |
  146. | length |
  147. | like |
  148. | ln |
  149. | load_file |
  150. | localtime |
  151. | localtimestamp |
  152. | locate |
  153. | log |
  154. | log10 |
  155. | log2 |
  156. | lower |
  157. | lpad |
  158. | lt |
  159. | ltrim |
  160. | make_set |
  161. | makedate |
  162. | maketime |
  163. | master_pos_wait |
  164. | md5 |
  165. | microsecond |
  166. | mid |
  167. | minus |
  168. | minute |
  169. | mod |
  170. | month |
  171. | monthname |
  172. | mul |
  173. | name_const |
  174. | ne |
  175. | nextval |
  176. | not |
  177. | now |
  178. | nulleq |
  179. | oct |
  180. | octet_length |
  181. | old_password |
  182. | or |
  183. | ord |
  184. | password_func |
  185. | period_add |
  186. | period_diff |
  187. | pi |
  188. | plus |
  189. | position |
  190. | pow |
  191. | power |
  192. | quarter |
  193. | quote |
  194. | radians |
  195. | rand |
  196. | random_bytes |
  197. | regexp |
  198. | release_all_locks |
  199. | release_lock |
  200. | repeat |
  201. | replace |
  202. | reverse |
  203. | right |
  204. | rightshift |
  205. | round |
  206. | row_count |
  207. | rpad |
  208. | rtrim |
  209. | schema |
  210. | sec_to_time |
  211. | second |
  212. | session_user |
  213. | setval |
  214. | setvar |
  215. | sha |
  216. | sha1 |
  217. | sha2 |
  218. | sign |
  219. | sin |
  220. | sleep |
  221. | sm3 |
  222. | space |
  223. | sqrt |
  224. | str_to_date |
  225. | strcmp |
  226. | subdate |
  227. | substr |
  228. | substring |
  229. | substring_index |
  230. | subtime |
  231. | sysdate |
  232. | system_user |
  233. | tan |
  234. | tidb_decode_key |
  235. | tidb_decode_plan |
  236. | tidb_is_ddl_owner |
  237. | tidb_parse_tso |
  238. | tidb_version |
  239. | time |
  240. | time_format |
  241. | time_to_sec |
  242. | timediff |
  243. | timestamp |
  244. | timestampadd |
  245. | timestampdiff |
  246. | to_base64 |
  247. | to_days |
  248. | to_seconds |
  249. | trim |
  250. | truncate |
  251. | ucase |
  252. | unaryminus |
  253. | uncompress |
  254. | uncompressed_length |
  255. | unhex |
  256. | unix_timestamp |
  257. | upper |
  258. | user |
  259. | utc_date |
  260. | utc_time |
  261. | utc_timestamp |
  262. | uuid |
  263. | uuid_short |
  264. | validate_password_strength |
  265. | version |
  266. | week |
  267. | weekday |
  268. | weekofyear |
  269. | weight_string |
  270. | xor |
  271. | year |
  272. | yearweek |
  273. +-----------------------------+
  274. 268 rows in set (0.00 sec)

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.