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

SQL command, type and function index

  • ! (logical NOT)
  • != (not equal)
  • "
  • % (modulo)
  • % (wildcard character)
  • & (bitwise AND)
  • && (logical AND)
  • () (parentheses)
  • (Control-Z) \z
  • * (multiplication)
  • + (addition)
  • - (subtraction)
  • - (unary minus)
  • -p option
  • -password option
  • .my.cnf file, .my.cnf file, .my.cnf file, .my.cnf file, .my.cnf file, .my.cnf file, .my.cnf file
  • .mysql_history file
  • .pid (process ID) file
  • / (division)
  • /etc/passwd
  • `/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()
  • alias
  • ALTER COLUMN
  • ALTER TABLE, ALTER TABLE, ALTER TABLE
  • ANALYZE TABLE
  • AND, bitwise
  • AND, logical
  • Area(), Area()
  • arithmetic functions
  • AS, AS
  • AsBinary()
  • ASCII()
  • ASIN()
  • AsText()
  • ATAN()
  • ATAN2()
  • AUTO_INCREMENT, using with DBI
  • AVG()

    • B

  • backspace (\b)
  • BACKUP TABLE
  • BdMPolyFromText()
  • BdMPolyFromWKB()
  • BdPolyFromText()
  • BdPolyFromWKB()
  • BEGIN
  • BENCHMARK()
  • BETWEEN ... AND
  • BIGINT
  • BIN()
  • BINARY
  • BIT
  • BIT_AND()
  • BIT_COUNT
  • BIT_COUNT()
  • BIT_LENGTH()
  • BIT_OR
  • BIT_OR()
  • BLOB, BLOB
  • BOOL
  • Boundary()
  • Buffer()

    • C

  • carriage return (\r)
  • CASE
  • CAST
  • casts
  • CC environment variable
  • CC environment variable, CC environment variable
  • CCX environment variable
  • CEILING()
  • Centroid(), Centroid()
  • CFLAGS environment variable, CFLAGS environment variable
  • CHAR, CHAR
  • CHAR VARYING
  • CHAR()
  • CHAR_LENGTH()
  • CHARACTER
  • CHARACTER VARYING
  • CHARACTER_LENGTH()
  • CHECK TABLE
  • ChopBlanks DBI method
  • COALESCE()
  • command-line options
  • Comment syntax
  • COMMIT, COMMIT
  • comparison operators
  • COMPRESS()
  • CONCAT()
  • CONCAT_WS()
  • configure option, --with-charset
  • configure option, --with-extra-charsets
  • connect() DBI method
  • CONNECTION_ID()
  • constraints
  • Contains()
  • control flow functions
  • CONV()
  • CONVERT
  • ConvexHull()
  • COS()
  • COT()
  • COUNT()
  • COUNT(DISTINCT)
  • CREATE DATABASE
  • CREATE FUNCTION
  • CREATE INDEX
  • CREATE TABLE
  • CROSS JOIN
  • Crosses()
  • CURDATE()
  • CURRENT_DATE
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • CURRENT_USER()
  • CURTIME()
  • CXX environment variable
  • CXX environment variable, CXX environment variable, CXX environment variable
  • CXXFLAGS environment variable, CXXFLAGS environment variable, CXXFLAGS environment variable, CXXFLAGS environment variable

    • D

  • data_sources() DBI method
  • DATABASE()
  • DATE, DATE, DATE
  • date and time functions
  • DATE_ADD()
  • DATE_FORMAT()
  • DATE_SUB()
  • DATETIME, DATETIME
  • DAYNAME()
  • DAYOFMONTH()
  • DAYOFWEEK()
  • DAYOFYEAR()
  • DBI->connect()
  • DBI->data_sources()
  • DBI->disconnect
  • DBI->do()
  • DBI->execute
  • DBI->fetchall_arrayref
  • DBI->fetchrow_array
  • DBI->fetchrow_arrayref
  • DBI->fetchrow_hashref
  • DBI->finish
  • DBI->prepare()
  • DBI->quote
  • DBI->quote()
  • DBI->rows
  • DBI->trace, DBI->trace
  • DBI->{ChopBlanks}
  • DBI->{insertid}
  • DBI->{is_blob}
  • DBI->{is_key}
  • DBI->{is_not_null}
  • DBI->{is_num}
  • DBI->{is_pri_key}
  • DBI->{length}
  • DBI->{max_length}
  • DBI->{NAME}
  • DBI->{NULLABLE}
  • DBI->{NUM_OF_FIELDS}
  • DBI->{table}
  • DBI->{type}
  • DBI_TRACE environment variable
  • DBI_TRACE environment variable, DBI_TRACE environment variable
  • DBI_USER environment variable
  • DEC
  • DECIMAL
  • DECODE()
  • DEGREES()
  • DELAYED
  • DELETE
  • DES_DECRYPT()
  • DES_ENCRYPT()
  • DESC
  • DESCRIBE, DESCRIBE
  • Difference()
  • Dimension()
  • disconnect DBI method
  • Disjoint()
  • Distance()
  • DISTINCT, DISTINCT, DISTINCT
  • DIV
  • division (/)
  • DO
  • do() DBI method
  • DOUBLE
  • DOUBLE PRECISION
  • double quote (\")
  • DROP DATABASE
  • DROP FUNCTION
  • DROP INDEX, DROP INDEX
  • DROP PRIMARY KEY
  • DROP TABLE
  • DUMPFILE

    • E

  • ELT()
  • ENCODE()
  • ENCRYPT()
  • EndPoint()
  • ENUM, ENUM
  • Envelope()
  • environment variable, CC
  • environment variable, CC
  • Environment variable, CC
  • Environment variable, CCX
  • Environment variable, CFLAGS
  • environment variable, CFLAGS
  • environment variable, CXX
  • environment variable, CXX
  • Environment variable, CXX
  • Environment variable, CXXFLAGS
  • environment variable, CXXFLAGS, environment variable, CXXFLAGS, environment variable, CXXFLAGS
  • environment variable, DBI_TRACE
  • Environment variable, DBI_TRACE, Environment variable, DBI_TRACE
  • Environment variable, DBI_USER
  • environment variable, HOME
  • Environment variable, HOME
  • environment variable, LD_RUN_PATH
  • Environment variable, LD_RUN_PATH, Environment variable, LD_RUN_PATH, Environment variable, LD_RUN_PATH
  • environment variable, MYSQL_DEBUG
  • Environment variable, MYSQL_DEBUG, Environment variable, MYSQL_DEBUG
  • Environment variable, MYSQL_HISTFILE
  • environment variable, MYSQL_HISTFILE
  • Environment variable, MYSQL_HOST
  • environment variable, MYSQL_HOST
  • Environment variable, MYSQL_PS1
  • Environment variable, MYSQL_PWD
  • environment variable, MYSQL_PWD, environment variable, MYSQL_PWD
  • Environment variable, MYSQL_TCP_PORT
  • environment variable, MYSQL_TCP_PORT, environment variable, MYSQL_TCP_PORT
  • environment variable, MYSQL_TCP_PORT
  • environment variable, MYSQL_UNIX_PORT
  • Environment variable, MYSQL_UNIX_PORT, Environment variable, MYSQL_UNIX_PORT
  • environment variable, MYSQL_UNIX_PORT, environment variable, MYSQL_UNIX_PORT
  • Environment variable, PATH
  • environment variable, PATH
  • Environment variable, TMPDIR, Environment variable, TMPDIR
  • Environment variable, TZ, Environment variable, TZ
  • Environment variable, UMASK, Environment variable, UMASK
  • Environment variable, UMASK_DIR, Environment variable, UMASK_DIR
  • environment variable, USER
  • Environment variable, USER
  • Environment variables, CXX
  • equal (=)
  • Equals()
  • escape (\\)
  • execute DBI method
  • EXP()
  • EXPLAIN
  • EXPORT_SET()
  • ExteriorRing()
  • EXTRACT()

    • F

  • fetchall_arrayref DBI method
  • fetchrow_array DBI method
  • fetchrow_arrayref DBI method
  • fetchrow_hashref DBI method
  • FIELD()
  • FILE
  • FIND_IN_SET()
  • finish DBI method
  • FLOAT, FLOAT
  • FLOAT(M,D)
  • FLOAT(precision), FLOAT(precision)
  • FLOOR()
  • FLUSH
  • FORCE INDEX, FORCE INDEX
  • FORMAT()
  • FOUND_ROWS()
  • FROM_DAYS()
  • FROM_UNIXTIME()
  • functions, arithmetic
  • functions, bit
  • functions, control flow
  • functions, date and time
  • functions, GROUP BY
  • functions, mathematical
  • functions, miscellaneous
  • functions, string
  • functions, string comparison
  • Functions, user-defined

    • G

  • GeomCollFromText()
  • GeomCollFromWKB()
  • GEOMETRY
  • GEOMETRYCOLLECTION
  • GeometryCollection()
  • GeometryCollectionFromText()
  • GeometryCollectionFromWKB()
  • GeometryFromText()
  • GeometryFromWKB()
  • GeometryN()
  • GeometryType()
  • GeomFromText(), GeomFromText()
  • GeomFromWKB(), GeomFromWKB()
  • GET_LOCK()
  • GLength(), GLength()
  • GRANT
  • GRANT statement, GRANT statement
  • GRANTS
  • greater than (>)
  • greater than or equal (>=)
  • GREATEST()
  • GROUP BY functions
  • GROUP_CONCAT()

    • H

  • HANDLER
  • HEX()
  • hexadecimal values
  • HOME environment variable
  • HOME environment variable
  • host.frm, problems finding
  • HOUR()

    • I

  • identifiers, quoting
  • IF()
  • IFNULL()
  • IGNORE INDEX, IGNORE INDEX
  • IGNORE KEY, IGNORE KEY
  • IN
  • INET_ATON()
  • INET_NTOA()
  • INNER JOIN
  • INSERT, INSERT
  • INSERT ... SELECT
  • INSERT DELAYED
  • INSERT statement, grant privileges
  • INSERT()
  • insertid DBI method
  • INSTR()
  • INT
  • INTEGER
  • InteriorRingN()
  • Intersection()
  • Intersects()
  • INTERVAL()
  • IS NOT NULL
  • IS NULL, IS NULL
  • IS NULL, and indexes
  • is_blob DBI method
  • IS_FREE_LOCK()
  • is_key DBI method
  • is_not_null DBI method
  • is_num DBI method
  • is_pri_key DBI method
  • IsClosed(), IsClosed()
  • IsEmpty()
  • ISNULL()
  • ISOLATION LEVEL
  • IsRing()
  • IsSimple()

    • J

  • JOIN

    • K

  • KILL

    • L

  • LAST_INSERT_ID()
  • LAST_INSERT_ID([expr])
  • LCASE()
  • LD_RUN_PATH environment variable, LD_RUN_PATH environment variable, LD_RUN_PATH environment variable, LD_RUN_PATH environment variable
  • LEAST()
  • LEFT JOIN, LEFT JOIN
  • LEFT OUTER JOIN
  • LEFT()
  • length DBI method
  • LENGTH()
  • less than (<)
  • less than or equal (<=)
  • LIKE
  • LIKE, and indexes
  • LIKE, and wildcards
  • LIMIT, LIMIT
  • LineFromText()
  • LineFromWKB()
  • LINESTRING
  • LineString()
  • LineStringFromText()
  • LineStringFromWKB()
  • LN()
  • LOAD DATA INFILE, LOAD DATA INFILE
  • LOAD_FILE()
  • LOCATE(), LOCATE()
  • LOCK TABLES
  • LOG()
  • LOG10()
  • LOG2()
  • Logical operators
  • LONGBLOB
  • LONGTEXT
  • LOWER()
  • LPAD()
  • LTRIM()

    • M

  • MAKE_SET()
  • MASTER_POS_WAIT()
  • MATCH ... AGAINST()
  • mathematical functions
  • MAX()
  • max_length DBI method
  • MBRContains()
  • MBRDisjoint()
  • MBREquals()
  • MBRIntersects()
  • MBROverlaps()
  • MBRTouches()
  • MBRWithin()
  • MD5()
  • MEDIUMBLOB
  • MEDIUMINT
  • MEDIUMTEXT
  • MID()
  • MIN()
  • minus, unary (-)
  • MINUTE()
  • miscellaneous functions
  • MLineFromText()
  • MLineFromWKB()
  • MOD()
  • modulo (%)
  • MONTH()
  • MONTHNAME()
  • MPointFromText()
  • MPointFromWKB()
  • MPolyFromText()
  • MPolyFromWKB()
  • MULTILINESTRING
  • MultiLineString()
  • MultiLineStringFromText()
  • MultiLineStringFromWKB()
  • multiplication (*)
  • MULTIPOINT
  • MultiPoint()
  • MultiPointFromText()
  • MultiPointFromWKB()
  • MULTIPOLYGON
  • MultiPolygon()
  • MultiPolygonFromText()
  • MultiPolygonFromWKB()
  • my_init()
  • my_ulonglong C type
  • my_ulonglong values, printing
  • MySQL C type
  • MYSQL C type
  • mysql_affected_rows()
  • mysql_autocommit().
  • MYSQL_BIND C type
  • mysql_bind_param()
  • mysql_bind_result()
  • mysql_change_user()
  • mysql_character_set_name()
  • mysql_close()
  • mysql_commit().
  • mysql_connect()
  • mysql_create_db()
  • mysql_data_seek()
  • MYSQL_DEBUG environment variable, MYSQL_DEBUG environment variable
  • MYSQL_DEBUG environment variable
  • mysql_debug()
  • mysql_drop_db()
  • mysql_dump_debug_info()
  • mysql_eof()
  • mysql_errno()
  • mysql_error()
  • mysql_escape_string()
  • mysql_execute()
  • mysql_fetch()
  • mysql_fetch_field()
  • mysql_fetch_field_direct()
  • mysql_fetch_fields()
  • mysql_fetch_lengths()
  • mysql_fetch_row()
  • MYSQL_FIELD C type
  • mysql_field_count(), mysql_field_count()
  • MYSQL_FIELD_OFFSET C type
  • mysql_field_seek()
  • mysql_field_tell()
  • mysql_free_result()
  • mysql_get_client_info()
  • mysql_get_host_info()
  • mysql_get_proto_info()
  • mysql_get_server_info()
  • mysql_get_server_version()
  • MYSQL_HISTFILE environment variable
  • MYSQL_HISTFILE environment variable
  • MYSQL_HOST environment variable
  • MYSQL_HOST environment variable
  • mysql_info()
  • mysql_info(), mysql_info(), mysql_info(), mysql_info()
  • mysql_init()
  • mysql_insert_id()
  • mysql_insert_id()
  • mysql_kill()
  • mysql_list_dbs()
  • mysql_list_fields()
  • mysql_list_processes()
  • mysql_list_tables()
  • mysql_more_results().
  • mysql_next_result().
  • mysql_num_fields()
  • mysql_num_rows()
  • mysql_options()
  • mysql_param_count()
  • mysql_ping()
  • mysql_prepare()
  • mysql_prepare_result.
  • MYSQL_PS1 environment variable
  • MYSQL_PWD environment variable, MYSQL_PWD environment variable
  • MYSQL_PWD environment variable
  • mysql_query(), mysql_query()
  • mysql_real_connect()
  • mysql_real_escape_string()
  • mysql_real_escape_string()
  • mysql_real_query()
  • mysql_reload()
  • MYSQL_RES C type
  • mysql_rollback().
  • MYSQL_ROW C type
  • mysql_row_seek()
  • mysql_row_tell()
  • mysql_select_db()
  • mysql_send_long_data().
  • mysql_server_end()
  • mysql_server_init()
  • mysql_shutdown()
  • mysql_sqlstate()
  • mysql_stat()
  • MYSQL_STMT C type
  • mysql_stmt_affected_rows()
  • mysql_stmt_close()
  • mysql_stmt_data_seek()
  • mysql_stmt_errno()
  • mysql_stmt_error().
  • mysql_stmt_num_rows()
  • mysql_stmt_row_seek()
  • mysql_stmt_row_tell()
  • mysql_stmt_sqlstate()
  • mysql_stmt_store_result()
  • mysql_store_result(), mysql_store_result()
  • MYSQL_TCP_PORT environment variable, MYSQL_TCP_PORT environment variable
  • MYSQL_TCP_PORT environment variable, MYSQL_TCP_PORT environment variable
  • mysql_thread_end()
  • mysql_thread_id()
  • mysql_thread_init()
  • mysql_thread_safe()
  • MYSQL_UNIX_PORT environment variable, MYSQL_UNIX_PORT environment variable
  • MYSQL_UNIX_PORT environment variable, MYSQL_UNIX_PORT environment variable, MYSQL_UNIX_PORT environment variable
  • mysql_use_result()

    • N

  • NAME DBI method
  • 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, NULL
  • NULL value
  • NULLABLE DBI method
  • NULLIF()
  • NUM_OF_FIELDS DBI method
  • NUMERIC
  • NumGeometries()
  • NumInteriorRings()
  • NumPoints()

    • O

  • OCT()
  • OCTET_LENGTH()
  • OLD_PASSWORD()
  • Operators, logical
  • OPTIMIZE TABLE
  • OR, bitwise
  • OR, logical
  • ORD()
  • ORDER BY
  • Overlaps()

    • P

  • parentheses ( and )
  • PASSWORD(), PASSWORD(), PASSWORD(), PASSWORD()
  • PATH environment variable, PATH environment variable
  • PERIOD_ADD()
  • PERIOD_DIFF()
  • PI()
  • POINT
  • Point()
  • PointFromText()
  • PointFromWKB()
  • PointN()
  • PointOnSurface(), PointOnSurface()
  • PolyFromText()
  • PolyFromWKB()
  • POLYGON
  • Polygon()
  • PolygonFromText()
  • PolygonFromWKB()
  • POSITION()
  • POW()
  • POWER()
  • prepare() DBI method
  • PRIMARY KEY, PRIMARY KEY
  • PROCESSLIST

    • Q

  • QUARTER()
  • QUOTE()
  • quote() DBI method
  • quoting of identifiers

    • R

  • RADIANS()
  • RAND()
  • REAL
  • ref_or_null
  • REGEXP
  • Related()
  • RELEASE_LOCK()
  • RENAME TABLE
  • REPAIR TABLE
  • REPEAT()
  • REPLACE
  • REPLACE ... SELECT
  • REPLACE()
  • REQUIRE GRANT option
  • RESTORE TABLE
  • return (\r)
  • REVERSE()
  • REVOKE
  • RIGHT JOIN
  • RIGHT OUTER JOIN
  • RIGHT()
  • RLIKE
  • ROLLBACK, ROLLBACK
  • ROLLUP
  • ROUND()
  • rows DBI method
  • RPAD()
  • RTRIM()

    • S

  • SEC_TO_TIME()
  • SECOND()
  • SELECT
  • SELECT INTO TABLE
  • SELECT speed
  • SELECT, optimising
  • SESSION_USER()
  • SET, 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()
  • SRID()
  • START TRANSACTION
  • StartPoint()
  • statements, GRANT
  • statements, INSERT
  • STD()
  • STDDEV()
  • STRAIGHT_JOIN
  • STRCMP()
  • string comparison functions
  • string functions
  • SUBDATE()
  • SUBSTRING(), SUBSTRING()
  • SUBSTRING_INDEX()
  • subtraction (-)
  • SUM()
  • SymDifference()
  • SYSDATE()
  • SYSTEM_USER()

    • T

  • tab (\t)
  • table DBI method
  • Table scan
  • table_cache
  • TAN()
  • TEXT, TEXT
  • threads
  • TIME, TIME
  • TIME_FORMAT()
  • TIME_TO_SEC()
  • TIMESTAMP, TIMESTAMP
  • TINYBLOB
  • TINYINT
  • TINYTEXT
  • TMPDIR environment variable, TMPDIR environment variable
  • TO_DAYS()
  • Touches()
  • trace DBI method, trace DBI method
  • TRIM()
  • TRUNCATE
  • TRUNCATE()
  • type DBI method
  • Types
  • TZ environment variable, TZ environment variable

    • U

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

    • V

  • VARCHAR, VARCHAR
  • VARIANCE()
  • VERSION()

    • W

  • WEEK()
  • WEEKDAY()
  • WHERE
  • Wildcard character (%)
  • Wildcard character (_)
  • Within()
  • without-server option

    • X

  • X()
  • XOR, bitwise
  • XOR, logical

    • Y

  • Y()
  • YEAR, YEAR
  • YEAR()

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

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