-
Notifications
You must be signed in to change notification settings - Fork 41
/
Copy pathfunctions.txt
117 lines (117 loc) · 855 Bytes
/
functions.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
and
or
not
xor
bitand
bitneg
bitor
bitxor
unaryminus
lt
le
eq
ne
ge
gt
nulleq
in
intdiv
isnull
like
istrue
isfalse
leftshift
rightshift
plus
minus
mul
div
abs
ceil
ceiling
floor
#asin
#acos
#atan
#atan2
#sin
#cos
#tan
#cot
crc32
radians
degrees
exp
sign
sqrt
ln
log
log2
log10
pow
power
case
if
ifnull
coalesce
json_type
json_extract
#json_unquote
json_array
json_object
json_merge
json_set
json_insert
#json_replace
json_remove
json_length
bit_length
length
hex
conv
ascii
#quote
concat
concat_ws
replace
strcmp
#locate
#instr
ltrim
rtrim
space
reverse
#right
#left
field
elt
year
month
#hour
#minute
#second
#microsecond
period_add
period_diff
#dayname
dayofmonth
dayofyear
from_days
#to_days
is_ipv4
is_ipv4_compat
is_ipv4_mapped
is_ipv6
inet_aton
inet_ntoa
inet6_aton
inet6_ntoa
uncompressed_length
md5
sha1
cast
mod
adddate
subdate
date_add
date_sub