Íîâîñòè
Äîêóìåíòàöèÿ
Download
Webboard
Ïîèñê
FAQ/×àÂî
Îáðàòíàÿ ñâÿçü




Function Index

ADDDATE(date,INTERVAL expr unit)

Section 11.6, “Date and Time Functions”

BENCHMARK(10, (SELECT * FROM t))

Section 11.11.3, “Information Functions”

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

Section 11.4, “String Functions”

CONCAT(p1.id, p1.tvab) + 0 AS tvid

Section 3.7.1, “Find All Nondistributed Twins”

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

Section 11.4, “String Functions”

CONVERT(expr USING transcoding_name)

Section 11.9, “Cast Functions and Operators”

CONVERT_TZ(...,...,@@global.time_zone)

Section 16.3.1, “Replication Features and Issues”

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

Section 16.3.1.27, “Replication and Time Zones”

DATE_ADD(date,INTERVAL expr unit)

Section 11.6, “Date and Time Functions”

DATE_SUB(date,INTERVAL expr unit)

Section 11.6, “Date and Time Functions”

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

Section 11.4, “String Functions”

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

Section 11.4, “String Functions”

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

Section 11.10, “XML Functions”

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

Section 11.10, “XML Functions”

ExtractValue(xml_frag, xpath_expr)

Section 11.10, “XML Functions”

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

Section 11.4, “String Functions”

FROM_UNIXTIME(unix_timestamp,format)

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATETIME,'INTERNAL')

Section 11.6, “Date and Time Functions”

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

Section 11.6, “Date and Time Functions”

INSERT(str,pos,len,newstr)

Section 11.4, “String Functions”

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

Section 11.4, “String Functions”

MASTER_POS_WAIT(log_name,log_pos[,timeout])

Section 11.11.4, “Miscellaneous Functions”

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

Section 11.8, “Full-Text Search Functions”

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

Section 3.6.9, “Using AUTO_INCREMENT

MIN(DATE_ADD(timestamp,INTERVAL 0 DAY))

Section 10.3.4, “Year 2000 Issues and Date Types”

REPLACE(str,from_str,to_str)

Section 11.4, “String Functions”

SOUNDEX(expr1) = SOUNDEX(expr2)

Section 11.4, “String Functions”

SUBDATE(date,INTERVAL expr unit)

Section 11.6, “Date and Time Functions”

SUBSTR(str FROM pos FOR len)

Section 11.4, “String Functions”

SUBSTRING(str FROM pos FOR len)

Section 11.4, “String Functions”

SUBSTRING_INDEX(str,delim,count)

Section 11.4, “String Functions”

TIMESTAMPADD(unit,interval,datetime_expr)

Section 11.6, “Date and Time Functions”

TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)

Section 11.6, “Date and Time Functions”

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

Section 11.4, “String Functions”

UNIX_TIMESTAMP(timestamp_column)

Section 18.2.1, “RANGE Partitioning”

UpdateXML(xml_target, xpath_expr, new_xml)

Section 11.10, “XML Functions”

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

Section 11.4, “String Functions”



ÐÅÊËÀÌÀ ÍÀ ÑÀÉÒÅ
  Ñîçäàíèå ñàéòîâ | |