Go to the first, previous, next, last section, table of contents.
!
!=
%
&
&&
(
)
*
+
-, -
/
<
<=
<>
=
>
>=
A
A BETWEEN B AND C
ABS()
ACOS(X)
ALTER TABLE
AND
Aritmetic expressions
ASCII(S)
ASIN(X)
ATAN(X)
ATAN2(X,Y)
AVG(expr)
B
BIGINT
BIT_AND(expr)
BIT_COUNT()
BIT_OR(expr)
BLOB
BLOB (Generic)
C
CEILING()
CHAR
CHAR(X,...)
CHAR_LENGTH(S)
CHARACTER_LENGTH(S)
ChopBlanks
CONCAT(X,Y...)
connect
COS(X)
COT(N)
COUNT(Expr)
CREATE DATABASE
CREATE INDEX
CREATE TABLE
CURDATE()
CURRENT_DATE()
CURRENT_TIME()
CURRENT_TIMESTAMP()
CURTIME()
D
data_sources
DATABASE()
DATE
DATE_FORMAT(Date, Format)
DATETIME
DAYOFMONTH(date expr)
DAYOFWEEK(date expr)
DAYOFYEAR(date expr)
DECIMAL
DEGREES(N)
DELETE
DELETE TABLE
DESC
DESCRIBE
disconnect
do
DOUBLE PRECISION
DROP DATABASE
DROP INDEX
E
ELT(N, A1, A2, A3...)
ENCRYPT(String[, Salt])
ENUM, ENUM
execute
EXP(N)
EXPLAIN
expr IN (value,...)
expr LIKE expr
expr NOT IN (value,...)
expr NOT LIKE expr
expr NOT REGEXP expr
expr REGEXP expr
F
fetchall_arrayref
fetchrow_array
fetchrow_arrayref
fetchrow_hashref
FIELD(S, S1, S2, S3...)
FIND_IN_SET(string,string of strings)
finish
FLOAT
FLOAT(4)
FLOAT(8)
FLOAT(M,D)
FLOOR()
FORMAT(Nr, Num)
FROM_DAYS()
FROM_UNIXTIME(Unix_timestamp)
FROM_UNIXTIME(Unix_timestamp, Format_string)
G
GRANT
H
HOUR(time expr)
I
IF(A,B,C)
IFNULL(A,B)
INSERT
INSERT(Org, Start, Length, New)
insertid
INSTR(A,B)
INT
INTERVAL(N, N1, N2, N3...)
is_blob
is_key
is_not_null
is_num
is_pri_key
ISNULL(A)
J
JOIN
L
LAST_INSERT_ID()
LCASE(A)
LEFT JOIN
LEFT(str,length)
length
LENGTH(S)
LIKE
LOAD DATA INFILE
LOCATE(A,B)
LOCATE(A,B,C)
LOCK TABLES
LOG(X)
LOG10(X)
LONGBLOB
LONGTEXT
LOWER(A)
LTRIM(str)
M
MAX(expr)
MAX(X,Y...)
max_length
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
MID(A, B, C)
MIN(expr)
MIN(X,Y...)
MINUTE(time expr)
MOD()
MONTH(date expr)
mysql_affected_rows
mysql_close
mysql_connect
mysql_create_db
mysql_data_seek
mysql_drop_db
mysql_eof
mysql_error
mysql_fetch_field
mysql_fetch_lengths
mysql_fetch_row
mysql_field_seek
mysql_free_result
mysql_get_client_info
mysql_get_host_info
mysql_get_proto_info
mysql_get_server_info
mysql_insert_id
mysql_list_dbs
mysql_list_fields
mysql_list_processes
mysql_list_tables
mysql_num_fields
mysql_num_rows
mysql_query
mysql_real_query
mysql_reload
mysql_select_db
mysql_shutdown
mysql_stat
mysql_store_result
mysql_use_result
N
NAME
NOT
NOW()
NULLABLE
NUM_OF_FIELDS
NUMERIC
O
OCTET_LENGTH(S)
OR
P
Parenthesis
PASSWORD(String)
PERIOD_ADD(P, N)
PERIOD_DIFF(A, B)
PI()
POSITION(B IN A)
POW(X,Y)
POWER(X,Y)
prepare
Q
QUARTER(date expr)
quote
R
RADIANS(N)
RAND([X])
REAL
REPEAT(String, Count)
REPLACE
REPLACE(A, B, C)
REVERSE(String)
RIGHT(A,B)
ROUND(N)
ROUND(Number,Decimals)
rows
RTRIM(str)
S
SEC_TO_TIME(Seconds)
SECOND(time expr)
SELECT
SESSION_USER()
SET, SET
SET OPTION
SHOW COLUMNS
SHOW DATABASES
SHOW FIELDS
SHOW INDEXE
SHOW KEYS
SHOW STATUS
SHOW TABLES
SHOW VARIABLES
SIGN()
SIN(X)
SMALLINT
SOUNDEX(S)
SPACE(N)
sqrt(X)
STD(expr)
STRCMP()
SUBSTRING(A FROM B FOR C)
SUBSTRING(A FROM B)
SUBSTRING(A, B, C)
SUBSTRING_INDEX(String, Delimiter, Count)
SUM(expr)
SYSDATE()
SYSTEM_USER()
T
table
TAN(X)
TEXT
TEXT (Generic)
TIME
TIME_TO_SEC(Time)
TIMESTAMP, TIMESTAMP
TINYBLOB
TINYINT
TINYTEXT
TO_DAYS(Date)
TRIM([[ BOTH | LEADING | TRAILING] [ A ] FROM ] B)
TRUNCATE(Number, Decimals)
Types
U
UCASE(A)
UNIX_TIMESTAMP([date expression])
UNLOCK TABLES
UPDATE
UPPER(A)
USER()
V
VARCHAR
VERSION
W
WEEK(date expr)
WEEKDAY(date expr)
Y
YEAR(date expr)
|
||
Go to the first, previous, next, last section, table of contents.
Casa de Bender