function

package
v0.2.0 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Sep 30, 2023 License: Apache-2.0 Imports: 25 Imported by: 0

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

View Source
const (
	FuncCastSign     = "CAST_SIGNED"
	FuncCastUnsigned = "CAST_UNSIGNED"
)
View Source
const (
	FuncSHA1 = "SHA1"
	FuncSHA  = "SHA"
)
View Source
const FuncAbs = "ABS"

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

View Source
const FuncAcos = "ACOS"

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

View Source
const FuncAsin = "ASIN"

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

View Source
const FuncCastChar = "CAST_CHAR"

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

View Source
const FuncCastCharset = "CAST_CHARSET"

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

View Source
const FuncCastDate = "CAST_DATE"

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

View Source
const FuncCastDatetime = "CAST_DATETIME"

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

View Source
const FuncCastDecimal = "CAST_DECIMAL"

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

View Source
const FuncCastNchar = "CAST_NCHAR"

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

View Source
const FuncCastTime = "CAST_TIME"

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

View Source
const FuncCeil = "CEIL"

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

View Source
const FuncCharLength = "CHAR_LENGTH"

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

View Source
const FuncConcat = "CONCAT"

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

View Source
const FuncConcatWS = "CONCAT_WS"

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

View Source
const FuncCos = "COS"

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

View Source
const FuncCumeDist = "CUME_DIST"

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

View Source
const FuncDenseRank = "DENSE_RANK"

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

View Source
const FuncExp = "EXP"

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

View Source
const FuncFirstValue = "FIRST_VALUE"

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

View Source
const FuncFloor = "FLOOR"

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

View Source
const FuncFormatBytes = "FORMAT_BYTES"
View Source
const FuncIf = "IF"

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

View Source
const FuncIfNull = "IFNULL"

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

View Source
const FuncLag = "LAG"

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

View Source
const FuncLastValue = "LAST_VALUE"

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

View Source
const FuncLead = "LEAD"

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

View Source
const FuncLeft = "LEFT"

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

View Source
const FuncLength = "LENGTH"
View Source
const FuncLower = "LOWER"

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

View Source
const FuncLpad = "LPAD"

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

View Source
const FuncLtrim = "LTRIM"

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

View Source
const FuncMd5 = "MD5"
View Source
const FuncMod = "MOD"

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

View Source
const FuncNthValue = "NTH_VALUE"

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

View Source
const FuncNtile = "NTILE"

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

View Source
const FuncPercentRank = "PERCENT_RANK"

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

View Source
const FuncPi = "PI"

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

View Source
const FuncPower = "POWER"

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

View Source
const FuncRand = "RAND"
View Source
const FuncRank = "RANK"

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

View Source
const FuncRepeat = "REPEAT"
View Source
const FuncReplace = "REPLACE"

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

View Source
const FuncReverse = "REVERSE"
View Source
const FuncRight = "RIGHT"

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

View Source
const FuncRound = "ROUND"

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

View Source
const FuncRowNumber = "ROW_NUMBER"

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

View Source
const FuncRpad = "RPAD"

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

View Source
const FuncRtrim = "RTRIM"

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

View Source
const FuncSin = "SIN"

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

View Source
const FuncSpace = "SPACE"
View Source
const FuncSqrt = "SQRT"

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

View Source
const FuncStrcmp = "STRCMP"

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

View Source
const FuncSubstring = "SUBSTRING"

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

View Source
const FuncTan = "TAN"

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

View Source
const FuncTruncate = "TRUNCATE"

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

View Source
const FuncUpper = "UPPER"

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

Variables

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

Functions

func Round

func Round(val float64, precision int) float64

Types

This section is empty.

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL