Tag: UTC ASI LCA Nat xor Date color file span
1. Category Navigation
1
2
3
4
5. Other types of functions
2. Character type function [approx. 48]
ASCII(Str) Bin (n) bit_length (Str)Char(N,...[using CharSet]) Character_length (Str) Char_length (Str) Compress (string_to_compress) concat_ws (separator,str1,str2,...) Conv (n,from_base,to_base) ELT (N,STR1,STR2,STR3,...) Export_set (Bits, on,off[, Separator[,number_of_bits]]) field (Str, STR1,STR2,STR3,...) Find_in_set (Str, Strlist) hex (n_or_s)Insert(StrPosLen, Newstr) InStr (Str, substr) LCase (Str) Left(Str,Len) Length (Str) Load_file (file_name) Locate (substr,Str), locate (substr,Str, POS)Lower(Str) Lpad (Str,Len, Padstr)LTrim(Str) Make_set (bits,str1,str2,...) Mid (StrPosLen) Oct (n) octet_length (Str) Ord (Str) position (substrinch Str) Quote (Str) Repeat (Str,Count)Replace(Str, From_str,to_str)Reverse(Str) Right(Str,Len) Rpad (Str,Len, Padstr)RTrim(Str)Soundex(Str)Space(n) strcmp (EXPR1,EXPR2)substring(Str, POS),substring(Str fromPossubstring(StrPosLen) ,substring(Str fromPos for Len) Substring_index (Str, Delim,Count) Trim ([{both | leading | trailing} [REMSTR] from]Str) Trim (remstr from]Str) UCase (Str) uncompress (string_to_uncompress) uncompressed_length (compressed_string) Unhex (Str)Upper(Str)
3. numeric function [approx. 25]
ABS(x)ACOs(x)ASIN(x)Atan(x) atan2 (y,x)Ceiling(x) ceil (x)Cos(x)Cot(x) crc32 (expr)degrees(x) divExp(x) Floor(x)log10(x) log2 (x) mod (n,m), n%m n MoD mPi() Pow (x, y),Power(x, y)radians(x)Rand()Rand(n)round(x)round(x,d) Sign(x)Sin(x)sqrt(x)Tan(x)
4. Date type function [approx. 65]
adddate (date,interval expr type) adddate (expr,days) addtime (EXPR,EXPR2) Convert_tz (Dt,from_tz,to_tz) curdate () current_date()Current_time()Current_timestamp() Curtime () date (expr)DateDiff(EXPR,EXPR2) date_add (date,interval expr type) date_format (Date,format) date_add (date,interval expr type) Day(date) Dayname (date) DayOfWeek (date) dayofyear (date) Extract (Type fromdate) DayOfMonth (date) from_days (n) from_unixtime (Unix_timestamp) from_unixtime (Unix_timestamp,format) get_ Format (Date|Time|datetime,'EUR'|'USA'|'JIS'|'ISO'|'Internal') hour (time) last_day (date) ln (x) localtime () Localtimestamp ()Log(x)Log(b,x) makedate ( Year, DayOfYear) maketime (hour,minute,second) microsecond (expr) minute (time)Month(date) monthname (date) Now () Period_add (p,n) Period_diff (P1,P2) quarter (date) second (time) sec_to_time (seconds) Str_to_date (Str, format) subdate (date,interval expr type) subdate (expr,days) subtime (EXPR,EXPR2) sysdate () time (expr) Timediff ( EXPR,EXPR2) Timestampadd (interval,int_expr,datetime_expr) Timestampdiff (INTERVAL,DATETIME_EXPR1,DATETIME_EXPR2) Time_format (Time,format) time_to_sec (time) to_days (date)truncate(x,d) Unix_timestamp () unix_timestamp (date) utc_date () Utc_time () Utc_timestamp () Week (date[, Mode]) Weekday (date) WeekOfYear (date) Year(date) Yearweek (date) Yearweek (Date,start)
5. Statistical functions [approx. 14]
avg([distinct]expr) Bit_and (expr) bit_or (expr) bit_xor (expr)Count(distinctExpr[Expr ...]) Group_concat (expr)min([distinct]Expr),Max([distinct]expr) std (expr) StdDev ( expr) stddev_pop (expr) stddev_samp (expr)sum([distinct]expr) variance (expr) var_pop (expr) var_samp (expr)
6. Other types of functions [approx. 44]
Aes_encrypt (Str, Key_str), Aes_decrypt (CRYPT_STR,KEY_STR) Benchmark (Count, expr)binarybit_count (n)cast(Expr asType),Convert(Expr,type),Convert(expr using transcoding_name) collation (Str) connection_id ()Current_User()Database() decode (CRYPT_STR,PASS_STR)default(col_name) Des_decrypt (Crypt_str[, Key_str]) Des_encrypt (Str[, (KEY_NUM|KEY_STR)]) Encode (Str, Pass_str) Encrypt (Str[, Salt]) format (x,d) found_rows () Get_lock (Str, timeout)if(EXPR1,EXPR2,EXPR3) ifnull (EXPR1,EXPR2) Inet_aton (expr) inet_ntoa (expr)IsNull(expr) Is_free_lock (Str) Is_used_lock (Str) master_pos_wait (Log_name,log_pos[, timeout]) MD5 (Str) Name_const (name,value)Nullif(EXPR1,EXPR2) Old_password (Str) Password (Str) Release_lock (Str) Row_count ()Schema()Session_user() SHA1 (Str) Sha (Str) Sleep (duration)System_user()timestamp(expr)timestamp(EXPR,EXPR2)User() uuid ()Values(col_name) version ()
Ext: 79033856
Ref: 78710482
Mysql Common set of functions