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. | greatest |
    90. | hex |
    91. | hour |
    92. | if |
    93. | ifnull |
    94. | in |
    95. | inet6_aton |
    96. | inet6_ntoa |
    97. | inet_aton |
    98. | inet_ntoa |
    99. | insert_func |
    100. | instr |
    101. | intdiv |
    102. | interval |
    103. | is_free_lock |
    104. | is_ipv4 |
    105. | is_ipv4_compat |
    106. | is_ipv4_mapped |
    107. | is_ipv6 |
    108. | is_used_lock |
    109. | isfalse |
    110. | isnull |
    111. | istrue |
    112. | json_array |
    113. | json_array_append |
    114. | json_array_insert |
    115. | json_contains |
    116. | json_contains_path |
    117. | json_depth |
    118. | json_extract |
    119. | json_insert |
    120. | json_keys |
    121. | json_length |
    122. | json_merge |
    123. | json_merge_patch |
    124. | json_merge_preserve |
    125. | json_object |
    126. | json_pretty |
    127. | json_quote |
    128. | json_remove |
    129. | json_replace |
    130. | json_search |
    131. | json_set |
    132. | json_storage_size |
    133. | json_type |
    134. | json_unquote |
    135. | json_valid |
    136. | last_day |
    137. | last_insert_id |
    138. | lastval |
    139. | lcase |
    140. | le |
    141. | least |
    142. | left |
    143. | leftshift |
    144. | length |
    145. | like |
    146. | ln |
    147. | load_file |
    148. | localtime |
    149. | localtimestamp |
    150. | locate |
    151. | log |
    152. | log10 |
    153. | log2 |
    154. | lower |
    155. | lpad |
    156. | lt |
    157. | ltrim |
    158. | make_set |
    159. | makedate |
    160. | maketime |
    161. | master_pos_wait |
    162. | md5 |
    163. | microsecond |
    164. | mid |
    165. | minus |
    166. | minute |
    167. | mod |
    168. | month |
    169. | monthname |
    170. | mul |
    171. | name_const |
    172. | ne |
    173. | nextval |
    174. | not |
    175. | now |
    176. | nulleq |
    177. | oct |
    178. | octet_length |
    179. | ord |
    180. | password_func |
    181. | period_add |
    182. | period_diff |
    183. | pi |
    184. | plus |
    185. | position |
    186. | pow |
    187. | power |
    188. | quarter |
    189. | quote |
    190. | radians |
    191. | rand |
    192. | random_bytes |
    193. | regexp |
    194. | release_all_locks |
    195. | release_lock |
    196. | repeat |
    197. | replace |
    198. | reverse |
    199. | right |
    200. | rightshift |
    201. | round |
    202. | row_count |
    203. | rpad |
    204. | rtrim |
    205. | schema |
    206. | sec_to_time |
    207. | second |
    208. | session_user |
    209. | setval |
    210. | setvar |
    211. | sha |
    212. | sha1 |
    213. | sha2 |
    214. | sign |
    215. | sin |
    216. | sleep |
    217. | space |
    218. | sqrt |
    219. | str_to_date |
    220. | strcmp |
    221. | subdate |
    222. | substr |
    223. | substring |
    224. | substring_index |
    225. | subtime |
    226. | sysdate |
    227. | system_user |
    228. | tan |
    229. | tidb_decode_key |
    230. | tidb_decode_plan |
    231. | tidb_is_ddl_owner |
    232. | tidb_parse_tso |
    233. | tidb_version |
    234. | time |
    235. | time_format |
    236. | time_to_sec |
    237. | timediff |
    238. | timestamp |
    239. | timestampadd |
    240. | timestampdiff |
    241. | to_base64 |
    242. | to_days |
    243. | to_seconds |
    244. | trim |
    245. | truncate |
    246. | ucase |
    247. | unaryminus |
    248. | uncompress |
    249. | uncompressed_length |
    250. | unhex |
    251. | unix_timestamp |
    252. | upper |
    253. | user |
    254. | utc_date |
    255. | utc_time |
    256. | utc_timestamp |
    257. | uuid |
    258. | uuid_short |
    259. | validate_password_strength |
    260. | version |
    261. | week |
    262. | weekday |
    263. | weekofyear |
    264. | weight_string |
    265. | xor |
    266. | year |
    267. | yearweek |
    268. +-----------------------------+