function

Documentation

Overview

Package function provides a set of mysql functions implements by Golang. Please see: https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html

Index

• Constants
• Variables
• func Round(val float64, precision int) float64

Constants

const (
	FuncCastSign     = "CAST_SIGNED"
	FuncCastUnsigned = "CAST_UNSIGNED"
)

const (
	FuncSHA1 = "SHA1"
	FuncSHA  = "SHA"
)

const FuncAbs = "ABS"

FuncAbs is https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_abs

const FuncAcos = "ACOS"

FuncAcos https://dev.mysql.com/doc/refman/5.6/en/mathematical-functions.html#function_acos

const FuncAsin = "ASIN"

FuncAsin https://dev.mysql.com/doc/refman/5.6/en/mathematical-functions.html#function_asin

const FuncCastChar = "CAST_CHAR"

FuncCastChar is https://dev.mysql.com/doc/refman/5.6/en/cast-functions.html#function_cast

const FuncCastCharset = "CAST_CHARSET"

FuncCastCharset FuncCastNchar is https://dev.mysql.com/doc/refman/5.6/en/cast-functions.html#function_cast

const FuncCastDate = "CAST_DATE"

FuncCastDate is https://dev.mysql.com/doc/refman/5.6/en/cast-functions.html#function_cast

const FuncCastDatetime = "CAST_DATETIME"

FuncCastDatetime is https://dev.mysql.com/doc/refman/5.6/en/cast-functions.html#function_cast

const FuncCastDecimal = "CAST_DECIMAL"

FuncCastDecimal is https://dev.mysql.com/doc/refman/5.6/en/cast-functions.html#function_cast

const FuncCastNchar = "CAST_NCHAR"

FuncCastNchar is https://dev.mysql.com/doc/refman/5.6/en/cast-functions.html#function_cast

const FuncCastTime = "CAST_TIME"

FuncCastTime is https://dev.mysql.com/doc/refman/5.6/en/cast-functions.html#function_cast

const FuncCeil = "CEIL"

FuncCeil is https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_ceil

const FuncCharLength = "CHAR_LENGTH"

FuncCharLength is https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_character-length

const FuncConcat = "CONCAT"

FuncConcat is https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_concat

const FuncConcatWS = "CONCAT_WS"

FuncConcatWS https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_concat-ws

const FuncCos = "COS"

FuncCos https://dev.mysql.com/doc/refman/5.6/en/mathematical-functions.html#function_cos

const FuncCumeDist = "CUME_DIST"

FuncCumeDist is https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html

const FuncDenseRank = "DENSE_RANK"

FuncDenseRank is https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html

const FuncExp = "EXP"

FuncExp is https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_exp

const FuncFirstValue = "FIRST_VALUE"

FuncFirstValue is https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html

const FuncFloor = "FLOOR"

FuncFloor is https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_floor

const FuncFormatBytes = "FORMAT_BYTES"

const FuncIf = "IF"

FuncIf is https://dev.mysql.com/doc/refman/5.6/en/flow-control-functions.html#function_if

const FuncIfNull = "IFNULL"

FuncIfNull is https://dev.mysql.com/doc/refman/5.6/en/flow-control-functions.html#function_ifnull

const FuncLag = "LAG"

FuncLag is https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html

const FuncLastValue = "LAST_VALUE"

FuncLastValue is https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html

const FuncLead = "LEAD"

FuncLead is https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html

const FuncLeft = "LEFT"

FuncLeft is https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_left

const FuncLength = "LENGTH"

const FuncLower = "LOWER"

FuncLower is https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_lower

const FuncLpad = "LPAD"

FuncLpad is https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_lpad

const FuncLtrim = "LTRIM"

FuncLtrim is https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_ltrim

const FuncMd5 = "MD5"

const FuncMod = "MOD"

FuncMod is https://dev.mysql.com/doc/refman/5.6/en/mathematical-functions.html#function_mod

const FuncNthValue = "NTH_VALUE"

FuncNthValue is https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html

const FuncNtile = "NTILE"

FuncNtile is https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html

const FuncPercentRank = "PERCENT_RANK"

FuncPercentRank is https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html

const FuncPi = "PI"

FuncPi is https://dev.mysql.com/doc/refman/5.6/en/mathematical-functions.html#function_pi

const FuncPower = "POWER"

FuncPower is https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_power

const FuncRand = "RAND"

const FuncRank = "RANK"

FuncRank is https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html

const FuncRepeat = "REPEAT"

const FuncReplace = "REPLACE"

FuncReplace is https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_replace

const FuncReverse = "REVERSE"

const FuncRight = "RIGHT"

FuncRight is https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_right

const FuncRound = "ROUND"

FuncRound is https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_round

const FuncRowNumber = "ROW_NUMBER"

FuncRowNumber is https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html

const FuncRpad = "RPAD"

FuncRpad is https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_rpad

const FuncRtrim = "RTRIM"

FuncRtrim is https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_rtrim

const FuncSin = "SIN"

FuncSin https://dev.mysql.com/doc/refman/5.6/en/mathematical-functions.html#function_sin

const FuncSpace = "SPACE"

const FuncSqrt = "SQRT"

FuncSqrt is https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_abs

const FuncStrcmp = "STRCMP"

FuncStrcmp is https://dev.mysql.com/doc/refman/5.6/en/string-comparison-functions.html

const FuncSubstring = "SUBSTRING"

FuncSubstring is https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_substring

const FuncTan = "TAN"

FuncTan https://dev.mysql.com/doc/refman/5.6/en/mathematical-functions.html#function_tan

const FuncTruncate = "TRUNCATE"

FuncTruncate is https://dev.mysql.com/doc/refman/5.6/en/mathematical-functions.html#function_truncate

const FuncUpper = "UPPER"

FuncUpper is https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_upper

Variables

var (
	DateSep = `[~!@#$%^&*_+=:;,.|/?\(\)\[\]\{\}\-\\]+`
)

var (
	DatetimeSep = `[~!@#$%^&*_+=:;,|/?\(\)\[\]\{\}\-\\]+`
)

Functions

func Round

func Round(val float64, precision int) float64