MySql函数索引介绍

2016-09-02 06:44:45 来源:www.45fan.com 【大中小】

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

本文地址：http://www.45fan.com/a/question/71041.html

Tags： mysql 函数索引

编辑：路饭网

上一篇：怎么样能够修复损坏的Word文档？

下一篇：如何在firefox中用CSS实现圆角矩形？

相关文章列表

如何在Linux系统安装MySql？	如何在windows下更改mysql root密码？
在CentOS系统下设置mysql每天自动备份的	MySQL动态字符串处理DYNAMIC_STRING的方
如何解决Mac Mysql数据库中文乱码的问题	MySQL命令行导出导入数据库实例有哪些？
怎么样查看linux服务器上mysql配置文件路	MySQL与Mongo简单的查询实例代码的详细介
如何使用mysql一次向表中插入多条数据？	怎么样使用索引技术优化MySQL数据库？

推广内容

推荐阅读

热门推荐

推荐文章

关于我们 | 联系我们 | 友情链接 | 网站地图 | Sitemap | App | 返回顶部