MySQL Function Index

MySQL Function Index

! (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)

<(Left shift)

<= (Less than or equal)

<=> (Equal)

<> (Not equal)

= (Equal)

> (Greater)

> = (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

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

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