Function Index

ADDDATE(date,INTERVAL expr unit)

Section 11.7, “Date and Time Functions”

BENCHMARK(10, (SELECT * FROM t))

Section 11.14, “Information Functions”

CHAR(N,... [USING charset_name])

Section 11.5, “String Functions”

CONCAT_WS(separator,str1,str2,...)

Section 11.5, “String Functions”

CONVERT(expr USING transcoding_name)

Section 11.10, “Cast Functions and Operators”

CONVERT_TZ(...,...,@@session.time_zone)

Section 15.4.1.28, “Replication and Time Zones”

DATE_ADD(date,INTERVAL expr unit)

Section 11.7, “Date and Time Functions”

DATE_SUB(date,INTERVAL expr unit)

Section 11.7, “Date and Time Functions”

ELT(N,str1,str2,str3,...)

Section 11.5, “String Functions”

EXPORT_SET(bits,on,off[,separator[,number_of_bits]])

Section 11.5, “String Functions”

ExtractValue('<a><b>Sakila</b></a>', '/a/b')

Section 11.11, “XML Functions”

ExtractValue('<a><b>Sakila</b></a>', '/a/b/text()')

Section 11.11, “XML Functions”

ExtractValue(xml_frag, xpath_expr)

Section 11.11, “XML Functions”

FIELD(str,str1,str2,str3,...)

Section 11.5, “String Functions”

FROM_UNIXTIME(unix_timestamp,format)

Section 11.7, “Date and Time Functions”

GET_FORMAT(DATETIME,'INTERNAL')

Section 11.7, “Date and Time Functions”

GET_FORMAT({DATE|TIME|DATETIME}, {'EUR'|'USA'|'JIS'|'ISO'|'INTERNAL'})

Section 11.7, “Date and Time Functions”

INSERT(str,pos,len,newstr)

Section 11.5, “String Functions”

MAKE_SET(bits,str1,str2,...)

Section 11.5, “String Functions”

MASTER_POS_WAIT(log_name,log_pos[,timeout])

Section 11.15, “Miscellaneous Functions”

MATCH (col1,col2,...) AGAINST (expr [search_modifier])

Section 11.9, “Full-Text Search Functions”

MAX(auto_increment_column) + 1 WHERE prefix=given-prefix

Section 3.6.9, “Using AUTO_INCREMENT

REPLACE(str,from_str,to_str)

Section 11.5, “String Functions”

SOUNDEX(expr1) = SOUNDEX(expr2)

Section 11.5, “String Functions”

SUBDATE(date,INTERVAL expr unit)

Section 11.7, “Date and Time Functions”

SUBSTR(str FROM pos FOR len)

Section 11.5, “String Functions”

SUBSTRING(str FROM pos FOR len)

Section 11.5, “String Functions”

SUBSTRING_INDEX(str,delim,count)

Section 11.5, “String Functions”

TIMESTAMPADD(unit,interval,datetime_expr)

Section 11.7, “Date and Time Functions”

TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)

Section 11.7, “Date and Time Functions”

TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str)

Section 11.5, “String Functions”

UNIX_TIMESTAMP(timestamp_column)

Section 17.2.1, “RANGE Partitioning”

UpdateXML(xml_target, xpath_expr, new_xml)

Section 11.11, “XML Functions”

WEIGHT_STRING(str [AS {CHAR|BINARY}(N)] [LEVEL levels] [flags])

Section 11.5, “String Functions”
    Поддержать сайт на родительском проекте КГБ