mysql.def

是一个很好的编辑器

; PSPad clip definition file for MySQL
;
; author: ing. Jan Fiala  [e-mail]
; last revision: 30.8.2003
;
[IFNULL | if expr1 is not NULL, IFNULL() returns expr1, else it returns expr2]
IFNULL(|expr1,expr2)
[NULLIF | if expr1 = expr2 is true, return NULL else return expr1]
NULLIF(|expr1,expr2)
[IF | if expr1 is TRUE (expr1 <> 0 and expr1 <> NULL) then IF() returns expr2, else it returns expr3]
IF(|expr1,expr2,expr3)
[CASE value | returns the result where value=compare-value]
CASE |value WHEN [compare-value] THEN result [WHEN [compare-value] THEN result ...] [ELSE result] END
[CASE when | returns the result for the first condition, which is true]
CASE WHEN [|condition] THEN result [WHEN [condition] THEN result ...] [ELSE result] END
[ASCII | returns the ASCII code value of the leftmost character of the string str]
ASCII(|str)
[ORD | returns the the ASCII code value of the character]
ORD(|str)
[CONV | converts numbers between different number bases]
CONV(|N,from_base,to_base)
[BIN | returns a string representation of the binary value of N, where N is a longlong (BIGINT) number]
BIN(|N)
[OCT | returns a string representation of the octal value of N]
OCT(|N)
[HEX | returns a string representation of the hexadecimal value of N]
HEX(|N)
[CHAR | returns a string consisting of the characters given by the ASCII code]
CHAR(|N,...)
[CONCAT | returns the string from concatenating the arguments]
CONCAT(|str1,str2,...)
[CONCAT_WS | the first argument is the separator for the rest of the arguments]
CONCAT_WS(|separator, str1, str2,...)
[LENGTH | returns the length of the string]
LENGTH(|str)
[OCTET_LENGTH | returns the length of the string]
OCTET_LENGTH(|str)
[CHAR_LENGTH | returns the length of the string]
CHAR_LENGTH(|str)
[CHARACTER_LENGTH | returns the length of the string str]
CHARACTER_LENGTH(|str)
[LOCATE | returns the position of the first occurrence of substring]
LOCATE(|substr,str)
[POSITION | returns the position of the first occurrence of substring]
POSITION(|substr IN str)
[LOCATE | returns the position of the first occurrence of substring]
LOCATE(|substr,str,pos)
[INSTR | returns the position of the first occurrence of substring]
INSTR(|str,substr)
[LPAD | returns the string str, left-padded with the string padstr]
LPAD(|str,len,padstr)
[RPAD | returns the string str, right-padded with the string padstr]
RPAD(|str,len,padstr)
[LEFT | returns the leftmost len characters from the string]
LEFT(|str,len)
[RIGHT | returns the rightmost len characters from the string]
RIGHT(|str,len)
[SUBSTRING | returns a substring from string str, starting at position pos]
SUBSTRING(|str,pos,len)
[SUBSTRING | returns a substring from string str, starting at position pos]
SUBSTRING(|str FROM pos FOR len)
[MID | returns a substring from string str, starting at position pos]
MID(|str,pos,len)
[SUBSTRING | returns a substring from string str, starting at position pos]
SUBSTRING(|str,pos)
[SUBSTRING | returns a substring from string str starting at position pos]
SUBSTRING(|str FROM pos)
[SUBSTRING_INDEX | returns the substring from string str before count occurrences of the delimiter delim]
SUBSTRING_INDEX(|str,delim,count)
[LTRIM | returns the string str with leading space characters removed]
LTRIM(|str)
[RTRIM | returns the string str with trailing space characters removed]
RTRIM(|str)
[TRIM | returns the string str with all remstr prefixes and/or suffixes removed]
TRIM(|[[BOTH | LEADING | TRAILING] [remstr] FROM] str)
[SOUNDEX | returns a soundex string from str]
SOUNDEX(|str)
[SPACE | returns a string consisting of N space characters]
SPACE(|N)
[REPLACE | returns the string str with from_str replaced by the string to_str]
REPLACE(|str,from_str,to_str)
[REPEAT | returns a string consisting of the string str repeated count times]
REPEAT(|str,count)
[REVERSE | returns the string str with the order of the characters reversed]
REVERSE(|str)
[INSERT | string beginning at position pos and len characters long is replaced by the newstr]
INSERT(|str,pos,len,newstr)
[ELT | returns str1 if N = 1, str2 if N = 2, and so on]
ELT(|N,str1,str2,str3,...)
[FIELD | returns the index of str in the str1, str2, str3, ... list]
FIELD(|str,str1,str2,str3,...)
[FIND_IN_SET | returns a value 1 to N if the string str is in the list strlist consisting of N substrings]
FIND_IN_SET(|str,strlist)
[MAKE_SET | returns a set consisting of the strings]
MAKE_SET(|bits,str1,str2,...)
[EXPORT_SET | returns a string frm set separated with 'separator']
EXPORT_SET(|bits,on,off,[separator,[number_of_bits]])
[LCASE | all characters are changed to lowercase]
LCASE(|str)
[LOWER | all characters are changed to lowercase]
LOWER(|str)
[UCASE | all characters changed to uppercase]
UCASE(|str)
[UPPER | all characters changed to uppercase]
UPPER(|str)
[LOAD_FILE | reads the file and returns the file contents as a string]
LOAD_FILE(|file_name)
[STRCMP | returns 0 if strings are same, -1 if first is smaller, 1 otherwise]
STRCMP(|expr1,expr2)
[MATCH  | is used for full-text search and returns relevance]
MATCH (|col1,col2,...) AGAINST (expr)
[ABS | returns the absolute value of X]
ABS(|X)
[SIGN | returns the sign of the argument as -1, 0, or 1, depending on whether X is negative, zero, or positive]
SIGN(|X)
[MOD | modulo (like the % operator in C). Returns the remainder of N divided by M]
MOD(|N,M)
[FLOOR | returns the largest integer value not greater than X]
FLOOR(|X)
[CEILING | returns the smallest integer value not less than X]
CEILING(|X)
[ROUND | returns the argument X, rounded to the nearest integer]
ROUND(|X)
[ROUND | returns the argument X, rounded to a number with D decimals. If D is 0, the result will have no decimal point or fractional part]
ROUND(|X,D)
[EXP | returns the value of e (the base of natural logarithms) raised to the power of X]
EXP(|X)
[LOG | returns the natural logarithm of X]
LOG(|X)
[LOG10 | returns the base-10 logarithm of X]
LOG10(|X)
[POW | returns the value of X raised to the power of Y]
POW(|X,Y)
[POWER | returns the value of X raised to the power of Y]
POWER(|X,Y)
[SQRT | returns the non-negative square root of X]
SQRT(|X)
[PI | returns the value of PI]
PI(|)
[COS | returns the cosine of X, where X is given in radians]
COS(|X)
[SIN | returns the sine of X, where X is given in radians]
SIN(|X)
[TAN | returns the tangent of X, where X is given in radians]
TAN(|X)
[ACOS | returns the arc cosine of X]
ACOS(|X)
[ASIN | returns the arc sine of X]
ASIN(|X)
[ATAN | returns the arc tangent of X]
ATAN(|X)
[ATAN2 | returns the arc tangent of the two variables X and Y]
ATAN2(|Y,X)
[COT | returns the cotangent of X]
COT(|X)
[RAND | random floating-point value in the range 0 to 1.0]
RAND(|)
[RAND | random floating-point value in the range 0 to 1.0]
RAND(|N)
[LEAST | returns the smallest argument]
LEAST(|X,Y,...)
[GREATEST | returns the largest argument]
GREATEST(|X,Y,...)
[DEGREES | returns the argument X, converted from radians to degrees]
DEGREES(|X)
[RADIANS | returns the argument X, converted from degrees to radians]
RADIANS(|X)
[TRUNCATE | returns the number X, truncated to D decimals]
TRUNCATE(|X,D)
[DAYOFWEEK | returns the weekday index for date (1 = Sunday