Go to the first, previous, next, last section, table of contents.

SQL command, type and function index.

  • !
  • !=
  • %
  • &
  • &&
  • (
  • )
  • *
  • +
  • -, -
  • /
  • <
  • <=
  • <>
  • =
  • >
  • >=

    • A

  • A BETWEEN B AND C
  • ABS()
  • ACOS(X)
  • ALTER TABLE
  • AND
  • Aritmetic functions
  • ASCII(S)
  • ASIN(X)
  • ATAN(X)
  • ATAN2(X,Y)
  • AVG(expr)

    • B

  • BIGINT
  • Bit functions
  • BIT_AND(expr)
  • BIT_COUNT()
  • BIT_OR(expr)
  • BLOB
  • BLOB (Generic)

    • C

  • CEILING()
  • CHAR
  • CHAR(X,...)
  • CHAR_LENGTH(S)
  • CHARACTER_LENGTH(S)
  • ChopBlanks
  • Comment syntax
  • Comparison operators
  • CONCAT(X,Y...)
  • connect
  • Control flow functions
  • COS(X)
  • COT(N)
  • COUNT(Expr)
  • CREATE DATABASE
  • CREATE FUNCTION
  • CREATE INDEX
  • CREATE TABLE
  • CURDATE()
  • CURRENT_DATE
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • CURTIME()

    • D

  • data_sources
  • DATABASE()
  • DATE
  • Date and time functions
  • DATE_FORMAT(Date, Format)
  • DATETIME
  • DAYNAME(date expr)
  • DAYOFMONTH(date expr)
  • DAYOFWEEK(date expr)
  • DAYOFYEAR(date expr)
  • DECIMAL
  • DEGREES(N)
  • DELETE
  • DELETE TABLE
  • DESC
  • DESCRIBE
  • disconnect
  • do
  • DOUBLE PRECISION
  • DROP DATABASE
  • DROP FUNCTION
  • 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
  • expr RLIKE 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

  • GET_LOCK(String,timeout)
  • GRANT
  • Group by functions

    • 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)
  • Logical functions
  • LONGBLOB
  • LONGTEXT
  • LOWER(A)
  • LTRIM(str)

    • M

  • Mathematical functions
  • MAX(expr)
  • MAX(X,Y...)
  • max_length
  • MEDIUMBLOB
  • MEDIUMINT
  • MEDIUMTEXT
  • MID(A, B, C)
  • MIN(expr)
  • MIN(X,Y...)
  • MINUTE(time expr)
  • Miscellaneous functions
  • MOD()
  • MONTH(date expr)
  • MONTHNAME(date expr)
  • mysql_affected_rows
  • mysql_close
  • mysql_connect
  • mysql_create_db
  • mysql_data_seek
  • mysql_drop_db
  • mysql_eof
  • mysql_error
  • mysql_escape_string
  • 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
  • RELEASE_LOCK(String)
  • 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 INDEX
  • SHOW KEYS
  • SHOW STATUS
  • SHOW TABLES
  • SHOW VARIABLES
  • SIGN()
  • SIN(X)
  • SMALLINT
  • SOUNDEX(S)
  • SPACE(N)
  • sqrt(X)
  • STD(expr)
  • STDDEV(expr) (Oracle format)
  • STRCMP()
  • String comparison functions
  • String functions
  • 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_FORMAT(time expr, format)
  • TIME_TO_SEC(Time)
  • TIMESTAMP, TIMESTAMP
  • TINYBLOB
  • TINYINT
  • TINYTEXT
  • TO_DAYS(Date)
  • TRIM([[ BOTH | LEADING | TRAILING] [ A ] FROM ] B)
  • TRUNCATE(Number, Decimals)

    • U

  • UCASE(A)
  • UDF functions
  • UNIX_TIMESTAMP([date expression])
  • UNLOCK TABLES
  • UPDATE
  • UPPER(A)
  • USER()

    • V

  • VARCHAR
  • VERSION

    • W

  • WEEK(date expr)
  • WEEKDAY(date expr)
  • WEEKDAY(Date)

    • Y

  • YEAR
  • YEAR(date expr)

  • |
  • ||
  • 型

    • Go to the first, previous, next, last section, table of contents.