我的书签
添加书签
移除书签SHOW BUILTINS
SHOW BUILTINS 语句用于列出 TiDB 中所有的内置函数。
语法图
ShowBuiltinsStmt:
示例
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. | space |
222. | sqrt |
223. | str_to_date |
224. | strcmp |
225. | subdate |
226. | substr |
227. | substring |
228. | substring_index |
229. | subtime |
230. | sysdate |
231. | system_user |
232. | tan |
233. | tidb_decode_key |
234. | tidb_decode_plan |
235. | tidb_is_ddl_owner |
236. | tidb_parse_tso |
237. | tidb_version |
238. | time |
239. | time_format |
240. | time_to_sec |
241. | timediff |
242. | timestamp |
243. | timestampadd |
244. | timestampdiff |
245. | to_base64 |
246. | to_days |
247. | to_seconds |
248. | trim |
249. | truncate |
250. | ucase |
251. | unaryminus |
252. | uncompress |
253. | uncompressed_length |
254. | unhex |
255. | unix_timestamp |
256. | upper |
257. | user |
258. | utc_date |
259. | utc_time |
260. | utc_timestamp |
261. | uuid |
262. | uuid_short |
263. | validate_password_strength |
264. | version |
265. | week |
266. | weekday |
267. | weekofyear |
268. | weight_string |
269. | xor |
270. | year |
271. | yearweek |
272. +-----------------------------+
273. 268 rows in set (0.00 sec)
MySQL 兼容性
该语句是 TiDB 对 MySQL 语法的扩展。
