MySql 函数索引

      MySql 函数索引

! (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 FUNCTION 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 FUNCTION 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() FLUSH FORCE INDEX FORCE INDEX FORMAT() FOUND_ROWS() FROM_DAYS() FROM_UNIXTIME()

G

GET_LOCK() GRANT GRANT statement GRANT statement GRANTS 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 statement, grant privileges INSERT() INSTR() INT INTEGER INTERVAL() IS NOT NULL IS NULL IS_FREE_LOCK() ISNULL() ISOLATION LEVEL

J

JOIN

K

KILL

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() OPTIMIZE TABLE 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() REQUIRE GRANT option RESTORE TABLE return (/r) REVERSE() REVOKE RIGHT JOIN RIGHT OUTER JOIN RIGHT() RLIKE ROLLBACK ROUND() RPAD() RTRIM()

S

SEC_TO_TIME() SECOND() SELECT SESSION_USER() SET SET SET OPTION SET PASSWORD statement SET TRANSACTION SHA() SHA1() SHOW COLUMNS SHOW CREATE TABLE, SHOW CREATE TABLE SHOW DATABASE INFO SHOW DATABASES SHOW FIELDS SHOW GRANTS SHOW GRANTS SHOW INDEX SHOW KEYS SHOW MASTER LOGS SHOW MASTER STATUS SHOW PRIVILEGES SHOW PROCESSLIST SHOW PROCESSLIST SHOW SLAVE STATUS SHOW STATUS SHOW TABLE STATUS SHOW TABLE TYPES SHOW TABLE TYPES SHOW TABLES SHOW VARIABLES SHOW WARNINGS SHOW WARNINGS SIGN() SIN() single quote (/') SMALLINT SOUNDEX() SOUNDS LIKE SPACE() SQL_CACHE SQL_NO_CACHE SQRT() START TRANSACTION statements, GRANT statements, INSERT STD() STDDEV() STRAIGHT_JOIN STRCMP() SUBDATE() SUBSTRING() SUBSTRING() SUBSTRING_INDEX() subtraction (-) SUM() SYSDATE() SYSTEM_USER()

T

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

U

UCASE() UDF functions ulimit UMASK environment variable UMASK environment variable UMASK_DIR environment variable UMASK_DIR environment variable unary minus (-) UNION UNION UNIQUE UNIX_TIMESTAMP() UNLOCK TABLES UPDATE UPPER() USE USE INDEX USE INDEX USE KEY USE KEY USER() User-defined functions

V

VARCHAR VARCHAR VARIANCE() VERSION()

W

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

X

XOR, bitwise XOR, logical

Y

YEAR YEAR YEAR()

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