现在的位置: 首页 > 综合 > 正文

mysql function列表

2013年10月15日 ⁄ 综合 ⁄ 共 3659字 ⁄ 字号 小 中 大 ⁄ 评论关闭
  • ! (logical NOT)
  • != (not equal)
  • "
  • % (modulo)
  • % (wildcard character)
  • & (bitwise AND)
  • && (logical AND)
  • () (06-3)
  • (Control-Z) /z
  • * (multiplication)
  • + (addition)
  • - (subtraction)
  • - (unary minus)
  • / (division)
  • /etc/passwd
  • < (less than)
  • << (left shift)
  • <= (less than or equal)
  • <=> (Equal to)
  • <> (not equal)
  • = (equal)
  • > (greater than)
  • >= (greater than or equal)
  • >> (right shift)
  • /" (double quote)
  • /' (single quote)
  • /0 (ASCII 0)
  • // (escape)
  • /b (backspace)
  • /n (newline)
  • /r (carriage return)
  • /t (tab)
  • /z (Control-Z) ASCII(26)
  • ^ (bitwise XOR)
  • _ (wildcard character)
  • `


    • A

  • ABS()
  • ACOS()
  • ADDDATE()
  • addition (+)
  • AES_DECRYPT()
  • AES_ENCRYPT()
  • ALTER COLUMN
  • ALTER TABLE
  • AND, bitwise
  • AND, logical
  • AS
  • AS
  • ASCII()
  • ASIN()
  • ATAN()
  • ATAN2()
  • AVG()


    • B

  • backspace (/b)
  • BEGIN
  • BENCHMARK()
  • BETWEEN ... AND
  • BIGINT
  • BIN()
  • BINARY
  • BIT
  • BIT_AND()
  • BIT_COUNT()
  • BIT_LENGTH()
  • BIT_OR()
  • BLOB
  • BLOB
  • BOOL


    • C

  • CASE
  • CAST
  • CEILING()
  • CHAR
  • CHAR
  • CHAR VARYING
  • CHAR()
  • CHAR_LENGTH()
  • CHARACTER
  • CHARACTER VARYING
  • CHARACTER_LENGTH()
  • COALESCE()
  • Comment syntax
  • COMMIT
  • CONCAT()
  • CONCAT_WS()
  • CONNECTION_ID()
  • control flow functions
  • CONV()
  • CONVERT
  • COS()
  • COT()
  • COUNT()
  • COUNT(DISTINCT)
  • CREATE DATABASE
  • CREATE INDEX
  • CREATE TABLE
  • CROSS JOIN
  • CURDATE()
  • CURRENT_DATE
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • CURRENT_USER()
  • CURTIME()


    • D

  • DATABASE()
  • DATE
  • DATE
  • DATE_ADD()
  • DATE_FORMAT()
  • DATE_SUB()
  • DATETIME
  • DATETIME
  • DAYNAME()
  • DAYOFMONTH()
  • DAYOFWEEK()
  • DAYOFYEAR()
  • DEC
  • DECIMAL
  • DECODE()
  • DEGREES()
  • DELAYED
  • DELETE
  • DES_DECRYPT()
  • DES_ENCRYPT()
  • DESC
  • DESCRIBE
  • DISTINCT
  • DIV
  • division (/)
  • DO
  • DOUBLE
  • DOUBLE PRECISION
  • double quote (/")
  • DROP DATABASE
  • DROP INDEX
  • DROP INDEX
  • DROP PRIMARY KEY
  • DROP TABLE
  • DUMPFILE


    • E

  • ELT()
  • ENCODE()
  • ENCRYPT()
  • ENUM
  • ENUM
  • equal (=)
  • escape (//)
  • EXP()
  • EXPORT_SET()
  • EXTRACT()


    • F

  • FIELD()
  • FILE
  • FIND_IN_SET()
  • FLOAT
  • FLOAT
  • FLOAT(M,D)
  • FLOAT(precision)
  • FLOAT(precision)
  • FLOOR()
  • FORCE INDEX
  • FORCE INDEX
  • FORMAT()
  • FOUND_ROWS()
  • FROM_DAYS()
  • FROM_UNIXTIME()


    • G

  • GET_LOCK()
  • greater than (>)
  • greater than or equal (>=)
  • GREATEST()
  • GROUP_CONCAT()


    • H

  • HANDLER
  • HEX()
  • hexadecimal values
  • HOUR()


    • I

  • identifiers, quoting
  • IF()
  • IFNULL()
  • IGNORE INDEX
  • IGNORE INDEX
  • IGNORE KEY
  • IGNORE KEY
  • IN
  • INET_ATON()
  • INET_NTOA()
  • INNER JOIN
  • INSERT
  • INSERT ... SELECT
  • INSERT DELAYED
  • INSERT()
  • INSTR()
  • INT
  • INTEGER
  • INTERVAL()
  • IS NOT NULL
  • IS NULL
  • IS_FREE_LOCK()
  • ISNULL()
  • ISOLATION LEVEL


    • J

  • JOIN


    • K

    L

  • LAST_INSERT_ID([expr])
  • LCASE()
  • LEAST()
  • LEFT JOIN
  • LEFT OUTER JOIN
  • LEFT()
  • LENGTH()
  • less than (<)
  • less than or equal (<=)
  • LIKE
  • LIMIT
  • LN()
  • LOAD DATA INFILE
  • LOAD_FILE()
  • LOCATE()
  • LOCATE()
  • LOCK TABLES
  • LOG()
  • LOG10()
  • LOG2()
  • LONGBLOB
  • LONGTEXT
  • LOWER()
  • LPAD()
  • LTRIM()


    • M

  • MAKE_SET()
  • MASTER_POS_WAIT()
  • MATCH ... AGAINST()
  • MAX()
  • MD5()
  • MEDIUMBLOB
  • MEDIUMINT
  • MEDIUMTEXT
  • MID()
  • MIN()
  • minus, unary (-)
  • MINUTE()
  • MOD()
  • modulo (%)
  • MONTH()
  • MONTHNAME()
  • multiplication (*)
  • mysql_info()
  • mysql_info()
  • mysql_info()
  • mysql_info()
  • mysql_real_escape_string()


    • N

  • NATIONAL CHAR
  • NATURAL LEFT JOIN
  • NATURAL LEFT OUTER JOIN
  • NATURAL RIGHT JOIN
  • NATURAL RIGHT OUTER JOIN
  • NCHAR
  • newline (/n)
  • NOT BETWEEN
  • not equal (!=)
  • not equal (<>)
  • NOT IN
  • NOT LIKE
  • NOT REGEXP
  • NOT, logical
  • NOW()
  • NUL
  • NULL value
  • NULLIF()
  • NUMERIC


    • O

  • OCT()
  • OCTET_LENGTH()
  • OLD_PASSWORD()
  • OR, bitwise
  • OR, logical
  • ORD()
  • ORDER BY


    • P

  • parentheses ( and )
  • PASSWORD()
  • PERIOD_ADD()
  • PERIOD_DIFF()
  • PI()
  • POSITION()
  • POW()
  • POWER()
  • PRIMARY KEY
  • PRIMARY KEY


    • Q

  • QUARTER()
  • QUOTE()
  • quoting of identifiers


    • R

  • RADIANS()
  • RAND()
  • REAL
  • REGEXP
  • RELEASE_LOCK()
  • RENAME TABLE
  • REPEAT()
  • REPLACE
  • REPLACE ... SELECT
  • REPLACE()
  • return (/r)
  • REVERSE()
  • RIGHT JOIN
  • RIGHT OUTER JOIN
  • RIGHT()
  • RLIKE
  • ROLLBACK
  • ROUND()
  • RPAD()
  • RTRIM()


    • S

  • SEC_TO_TIME()
  • SECOND()
  • SELECT
  • SESSION_USER()
  • SET
  • SET
  • SET TRANSACTION
  • SHA()
  • SHA1()
  • SIGN()
  • SIN()
  • single quote (/')
  • SMALLINT
  • SOUNDEX()
  • SOUNDS LIKE
  • SPACE()
  • SQL_CACHE
  • SQL_NO_CACHE
  • SQRT()
  • START TRANSACTION
  • STD()
  • STDDEV()
  • STRAIGHT_JOIN
  • STRCMP()
  • SUBDATE()
  • SUBSTRING()
  • SUBSTRING()
  • SUBSTRING_INDEX()
  • subtraction (-)
  • SUM()
  • SYSDATE()
  • SYSTEM_USER()


    • T

  • tab (/t)
  • TAN()
  • TEXT
  • TEXT
  • TIME
  • TIME
  • TIME_FORMAT()
  • TIME_TO_SEC()
  • TIMESTAMP
  • TIMESTAMP
  • TINYBLOB
  • TINYINT
  • TINYTEXT
  • TO_DAYS()
  • TRIM()
  • TRUNCATE
  • TRUNCATE()
  • Types


    • U

  • UCASE()
  • unary minus (-)
  • UNION
  • UNIQUE
  • UNIX_TIMESTAMP()
  • UNLOCK TABLES
  • UPDATE
  • UPPER()
  • USE
  • USE INDEX
  • USE INDEX
  • USE KEY
  • USE KEY
  • USER()

    V

  • VARCHAR
  • VARCHAR
  • VARIANCE()
  • VERSION()


    • W

  • WEEK()
  • WEEKDAY()
  • Wildcard character (%)
  • Wildcard character (_)


    • X

  • XOR, bitwise
  • XOR, logical


    • Y

  • YEAR
  • YEAR
  • YEAR()

  • | (bitwise OR)
  • || (logical OR)
  • ~

    •  
    返回
    【上篇】
    【下篇】

    作者:

    抱歉!评论已关闭.

    返回首页

    Copyright © 2013-2018 学步园  保留所有权利.
    软文销售 QQ客服：2265327166 点击这里给我发消息（其他合作也可洽谈）
    必威体育
    必威电竞