TOC

MySQL help

输入 help 之后,按照提示就会发现 MySQL 有一个主题树。
从头 help contents 开始:

  • Account Management
    • ALTER RESOURCE GROUP
    • ALTER USER
    • CREATE RESOURCE GROUP
    • CREATE ROLE
    • CREATE USER
    • DROP RESOURCE GROUP
    • DROP ROLE
    • DROP USER
    • GRANT
    • RENAME USER
    • REVOKE
    • SET DEFAULT ROLE
    • SET PASSWORD
    • SET RESOURCE GROUP
    • SET ROLE
  • Administration
    • BINLOG
    • CACHE INDEX
    • FLUSH
    • HELP COMMAND
    • KILL
    • LOAD INDEX
    • RESET
    • RESET PERSIST
    • RESTART
    • SET
    • SET CHARACTER SET
    • SET CHARSET
    • SET NAMES
    • SHOW
    • SHOW BINARY LOGS
    • SHOW BINLOG EVENTS
    • SHOW CHARACTER SET
    • SHOW COLLATION
    • SHOW COLUMNS
    • SHOW CREATE DATABASE
    • SHOW CREATE EVENT
    • SHOW CREATE FUNCTION
    • SHOW CREATE PROCEDURE
    • SHOW CREATE SCHEMA
    • SHOW CREATE TABLE
    • SHOW CREATE TRIGGER
    • SHOW CREATE USER
    • SHOW CREATE VIEW
    • SHOW DATABASES
    • SHOW ENGINE
    • SHOW ENGINES
    • SHOW ERRORS
    • SHOW EVENTS
    • SHOW FIELDS
    • SHOW FUNCTION CODE
    • SHOW FUNCTION STATUS
    • SHOW GRANTS
    • SHOW INDEX
    • SHOW MASTER LOGS
    • SHOW MASTER STATUS
    • SHOW OPEN TABLES
    • SHOW PLUGINS
    • SHOW PRIVILEGES
    • SHOW PROCEDURE CODE
    • SHOW PROCEDURE STATUS
    • SHOW PROCESSLIST
    • SHOW PROFILE
    • SHOW PROFILES
    • SHOW RELAYLOG EVENTS
    • SHOW REPLICA STATUS
    • SHOW REPLICAS
    • SHOW SCHEMAS
    • SHOW SLAVE HOSTS
    • SHOW SLAVE STATUS
    • SHOW STATUS
    • SHOW TABLE STATUS
    • SHOW TABLES
    • SHOW TRIGGERS
    • SHOW VARIABLES
    • SHOW WARNINGS
    • SHUTDOWN
  • Components
    • CLONE
    • INSTALL COMPONENT
    • UNINSTALL COMPONENT
    • UNINSTALL PLUGIN
  • Compound Statements
    • BEGIN END
    • CASE STATEMENT
    • CLOSE
    • DECLARE CONDITION
    • DECLARE CURSOR
    • DECLARE HANDLER
    • DECLARE VARIABLE
    • FETCH
    • GET DIAGNOSTICS
    • IF STATEMENT
    • ITERATE
    • LABELS
    • LEAVE
    • LOOP
    • OPEN
    • REPEAT LOOP
    • RESIGNAL
    • RETURN
    • SIGNAL
    • WHILE
  • Contents
  • Data Definition
    • ALTER DATABASE
    • ALTER EVENT
    • ALTER FUNCTION
    • ALTER INSTANCE
    • ALTER LOGFILE GROUP
    • ALTER PROCEDURE
    • ALTER SCHEMA
    • ALTER SERVER
    • ALTER TABLE
    • ALTER TABLESPACE
    • ALTER VIEW
    • CREATE DATABASE
    • CREATE EVENT
    • CREATE FUNCTION
    • CREATE INDEX
    • CREATE LOGFILE GROUP
    • CREATE PROCEDURE
    • CREATE SCHEMA
    • CREATE SERVER
    • CREATE SPATIAL REFERENCE SYSTEM
    • CREATE TABLE
    • CREATE TABLESPACE
    • CREATE TRIGGER
    • CREATE VIEW
    • DROP DATABASE
    • DROP EVENT
    • DROP FUNCTION
    • DROP INDEX
    • DROP PROCEDURE
    • DROP SCHEMA
    • DROP SERVER
    • DROP SPATIAL REFERENCE SYSTEM
    • DROP TABLE
    • DROP TABLESPACE
    • DROP TRIGGER
    • DROP VIEW
    • FOREIGN KEY
    • RENAME TABLE
    • TRUNCATE TABLE
  • Data Manipulation
    • CALL
    • DELETE
    • DO
    • DUAL
    • HANDLER
    • IMPORT TABLE
    • INSERT
    • INSERT DELAYED
    • INSERT SELECT
    • JOIN
    • LOAD DATA
    • LOAD XML
    • PARENTHESIZED QUERY EXPRESSIONS
    • REPLACE
    • SELECT
    • TABLE
    • UNION
    • UPDATE
    • VALUES STATEMENT
  • Data Types
    • AUTO_INCREMENT
    • BIGINT
    • BINARY
    • BIT
    • BLOB
    • BLOB DATA TYPE
    • BOOLEAN
    • CHAR
    • CHAR BYTE
    • DATE
    • DATETIME
    • DEC
    • DECIMAL
    • DOUBLE
    • DOUBLE PRECISION
    • ENUM
    • FLOAT
    • INT
    • INTEGER
    • LONGBLOB
    • LONGTEXT
    • MEDIUMBLOB
    • MEDIUMINT
    • MEDIUMTEXT
    • SET DATA TYPE
    • SMALLINT
    • TEXT
    • TIME
    • TIMESTAMP
    • TINYBLOB
    • TINYINT
    • TINYTEXT
    • VARBINARY
    • VARCHAR
    • YEAR DATA TYPE
  • Functions
    • Aggregate Functions and Modifiers
      • AVG
      • BIT_AND
      • BIT_OR
      • BIT_XOR
      • COUNT
      • COUNT DISTINCT
      • GROUP_CONCAT
      • JSON_ARRAYAGG
      • JSON_OBJECTAGG
      • MAX
      • MIN
      • STD
      • STDDEV
      • STDDEV_POP
      • STDDEV_SAMP
      • SUM
      • VARIANCE
      • VAR_POP
      • VAR_SAMP
    • Bit Functions
      • &
      • <<
      • >>
      • BIT_COUNT
      • ^
      • |
      • ~
    • Cast Functions and Operators
      • BINARY OPERATOR
      • CAST
      • CONVERT
    • Comparison Operators
      • !=
      • <
      • <=
      • <=>
      • =
      • >
      • >=
      • BETWEEN AND
      • COALESCE
      • GREATEST
      • IN
      • INTERVAL
      • IS
      • IS NOT
      • IS NOT NULL
      • IS NULL
      • ISNULL
      • LEAST
      • NOT BETWEEN
      • NOT IN
    • Date and Time Functions
      • ADDDATE
      • ADDTIME
      • CONVERT_TZ
      • CURDATE
      • CURRENT_DATE
      • CURRENT_TIME
      • CURRENT_TIMESTAMP
      • CURTIME
      • DATE FUNCTION
      • DATEDIFF
      • DATE_ADD
      • DATE_FORMAT
      • DATE_SUB
      • DAY
      • DAYNAME
      • DAYOFMONTH
      • DAYOFWEEK
      • DAYOFYEAR
      • EXTRACT
      • FROM_DAYS
      • FROM_UNIXTIME
      • GET_FORMAT
      • HOUR
      • LAST_DAY
      • LOCALTIME
      • LOCALTIMESTAMP
      • MAKEDATE
      • MAKETIME
      • MICROSECOND
      • MINUTE
      • MONTH
      • MONTHNAME
      • NOW
      • PERIOD_ADD
      • PERIOD_DIFF
      • QUARTER
      • SECOND
      • SEC_TO_TIME
      • STR_TO_DATE
      • SUBDATE
      • SUBTIME
      • SYSDATE
      • TIME FUNCTION
      • TIMEDIFF
      • TIMESTAMP FUNCTION
      • TIMESTAMPADD
      • TIMESTAMPDIFF
      • TIME_FORMAT
      • TIME_TO_SEC
      • TO_DAYS
      • TO_SECONDS
      • UNIX_TIMESTAMP
      • UTC_DATE
      • UTC_TIME
      • UTC_TIMESTAMP
      • WEEK
      • WEEKDAY
      • WEEKOFYEAR
      • YEAR
      • YEARWEEK
    • Encryption Functions
      • AES_DECRYPT
      • AES_ENCRYPT
      • COMPRESS
      • MD5
      • RANDOM_BYTES
      • SHA1
      • SHA2
      • STATEMENT_DIGEST
      • STATEMENT_DIGEST_TEXT
      • UNCOMPRESS
      • UNCOMPRESSED_LENGTH
      • VALIDATE_PASSWORD_STRENGTH
    • Enterprise Encryption Functions
      • ASYMMETRIC_DECRYPT
      • ASYMMETRIC_DERIVE
      • ASYMMETRIC_ENCRYPT
      • ASYMMETRIC_SIGN
      • ASYMMETRIC_VERIFY
      • CREATE_ASYMMETRIC_PRIV_KEY
      • CREATE_ASYMMETRIC_PUB_KEY
      • CREATE_DH_PARAMETERS
      • CREATE_DIGEST
    • Flow Control Functions
      • CASE OPERATOR
      • IF FUNCTION
      • IFNULL
      • NULLIF
    • GROUP BY Functions and Modifiers
    • GTID
      • GTID_SUBSET
      • GTID_SUBTRACT
      • WAIT_FOR_EXECUTED_GTID_SET
      • WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS
    • Information Functions
      • BENCHMARK
      • CHARSET
      • COERCIBILITY
      • COLLATION
      • CONNECTION_ID
      • CURRENT_ROLE
      • CURRENT_USER
      • DATABASE
      • FOUND_ROWS
      • ICU_VERSION
      • LAST_INSERT_ID
      • ROLES_GRAPHML
      • ROW_COUNT
      • SCHEMA
      • SESSION_USER
      • SYSTEM_USER
      • USER
      • VERSION
    • Internal Functions
      • CAN_ACCESS_COLUMN
      • CAN_ACCESS_DATABASE
      • CAN_ACCESS_TABLE
      • CAN_ACCESS_USER
      • CAN_ACCESS_VIEW
      • GET_DD_COLUMN_PRIVILEGES
      • GET_DD_CREATE_OPTIONS
      • GET_DD_INDEX_SUB_PART_LENGTH
      • INTERNAL_AUTO_INCREMENT
      • INTERNAL_AVG_ROW_LENGTH
      • INTERNAL_CHECKSUM
      • INTERNAL_CHECK_TIME
      • INTERNAL_DATA_FREE
      • INTERNAL_DATA_LENGTH
      • INTERNAL_DD_CHAR_LENGTH
      • INTERNAL_GET_COMMENT_OR_ERROR
      • INTERNAL_GET_ENABLED_ROLE_JSON
      • INTERNAL_GET_HOSTNAME
      • INTERNAL_GET_USERNAME
      • INTERNAL_GET_VIEW_WARNING_OR_ERROR
      • INTERNAL_INDEX_COLUMN_CARDINALITY
      • INTERNAL_INDEX_LENGTH
      • INTERNAL_IS_ENABLED_ROLE
      • INTERNAL_IS_MANDATORY_ROLE
      • INTERNAL_KEYS_DISABLED
      • INTERNAL_MAX_DATA_LENGTH
      • INTERNAL_TABLE_ROWS
      • INTERNAL_UPDATE_TIME
      • IS_VISIBLE_DD_OBJECT
    • Locking Functions
      • GET_LOCK
      • IS_FREE_LOCK
      • IS_USED_LOCK
      • RELEASE_ALL_LOCKS
      • RELEASE_LOCK
    • Logical Operators
      • !
      • AND
      • ASSIGN-EQUAL
      • ASSIGN-VALUE
      • OR
      • XOR
    • Miscellaneous Functions
      • ANY_VALUE
      • BIN_TO_UUID
      • DEFAULT
      • GROUPING
      • INET6_ATON
      • INET6_NTOA
      • INET_ATON
      • INET_NTOA
      • IS_IPV4
      • IS_IPV4_COMPAT
      • IS_IPV4_MAPPED
      • IS_IPV6
      • IS_UUID
      • MASTER_POS_WAIT
      • NAME_CONST
      • SLEEP
      • SOURCE_POS_WAIT
      • UUID
      • UUID_SHORT
      • UUID_TO_BIN
      • VALUES
    • Numeric Functions
      • %
      • *
      • +
      • - BINARY
      • - UNARY
      • /
      • ABS
      • ACOS
      • ASIN
      • ATAN
      • ATAN2
      • CEIL
      • CEILING
      • CONV
      • COS
      • COT
      • CRC32
      • DEGREES
      • DIV
      • EXP
      • FLOOR
      • LN
      • LOG
      • LOG10
      • LOG2
      • MOD
      • PI
      • POW
      • POWER
      • RADIANS
      • RAND
      • ROUND
      • SIGN
      • SIN
      • SQRT
      • TAN
      • TRUNCATE
    • Performance Schema Functions
      • FORMAT_BYTES
      • FORMAT_PICO_TIME
      • PS_CURRENT_THREAD_ID
      • PS_THREAD_ID
    • Spatial Functions
      • Geometry Constructors
        • GEOMCOLLECTION
        • GEOMETRYCOLLECTION
        • LINESTRING
        • MULTILINESTRING
        • MULTIPOINT
        • MULTIPOLYGON
        • POINT
        • POLYGON
      • Geometry Property Functions
        • ST_DIMENSION
        • ST_ENVELOPE
        • ST_GEOMETRYTYPE
        • ST_ISEMPTY
        • ST_ISSIMPLE
        • ST_SRID
      • Geometry Relation Functions
        • ST_CONTAINS
        • ST_CROSSES
        • ST_DISJOINT
        • ST_DISTANCE
        • ST_EQUALS
        • ST_FRECHETDISTANCE
        • ST_HAUSDORFFDISTANCE
        • ST_INTERSECTS
        • ST_OVERLAPS
        • ST_TOUCHES
        • ST_WITHIN
      • GeometryCollection Property Functions
        • ST_BUFFER
        • ST_BUFFER_STRATEGY
        • ST_CONVEXHULL
        • ST_DIFFERENCE
        • ST_GEOMETRYN
        • ST_INTERSECTION
        • ST_LINEINTERPOLATEPOINT
        • ST_LINEINTERPOLATEPOINTS
        • ST_NUMGEOMETRIES
        • ST_POINTATDISTANCE
        • ST_SYMDIFFERENCE
        • ST_TRANSFORM
        • ST_UNION
      • LineString Property Functions
        • ST_ENDPOINT
        • ST_ISCLOSED
        • ST_LENGTH
        • ST_NUMPOINTS
        • ST_POINTN
        • ST_STARTPOINT
      • MBR Functions
        • ->
        • ->>
        • JSON_ARRAY
        • JSON_ARRAY_APPEND
        • JSON_ARRAY_INSERT
        • JSON_CONTAINS
        • JSON_CONTAINS_PATH
        • JSON_DEPTH
        • JSON_EXTRACT
        • JSON_INSERT
        • JSON_KEYS
        • JSON_LENGTH
        • JSON_MERGE
        • JSON_MERGE_PATCH()
        • JSON_MERGE_PRESERVE()
        • JSON_OBJECT
        • JSON_OVERLAPS
        • JSON_PRETTY
        • JSON_QUOTE
        • JSON_REMOVE
        • JSON_REPLACE
        • JSON_SCHEMA_VALID
        • JSON_SCHEMA_VALIDATION_REPORT
        • JSON_SEARCH
        • JSON_SET
        • JSON_STORAGE_FREE
        • JSON_STORAGE_SIZE
        • JSON_TABLE
        • JSON_TYPE
        • JSON_UNQUOTE
        • JSON_VALID
        • JSON_VALUE
        • MBRCONTAINS
        • MBRCOVEREDBY
        • MBRCOVERS
        • MBRDISJOINT
        • MBREQUALS
        • MBRINTERSECTS
        • MBROVERLAPS
        • MBRTOUCHES
        • MBRWITHIN
        • MEMBER OF
        • ST_ASGEOJSON
        • ST_COLLECT
        • ST_DISTANCE_SPHERE
        • ST_GEOHASH
        • ST_GEOMFROMGEOJSON
        • ST_ISVALID
        • ST_LATFROMGEOHASH
        • ST_LONGFROMGEOHASH
        • ST_MAKEENVELOPE
        • ST_POINTFROMGEOHASH
        • ST_SIMPLIFY
        • ST_VALIDATE
      • Point Property Functions
        • ST_LATITUDE
        • ST_LONGITUDE
        • ST_X
        • ST_Y
      • Polygon Property Functions
        • ST_AREA
        • ST_CENTROID
        • ST_EXTERIORRING
        • ST_INTERIORRINGN
        • ST_NUMINTERIORRINGS
      • WKB Functions
        • ST_ASBINARY
        • ST_ASTEXT
        • ST_GEOMCOLLFROMWKB
        • ST_GEOMFROMWKB
        • ST_LINEFROMWKB
        • ST_MLINEFROMWKB
        • ST_MPOINTFROMWKB
        • ST_MPOLYFROMWKB
        • ST_POINTFROMWKB
        • ST_POLYFROMWKB
        • ST_SWAPXY
      • WKT Functions
        • ST_GEOMCOLLFROMTEXT
        • ST_GEOMFROMTEXT
        • ST_LINEFROMTEXT
        • ST_MLINEFROMTEXT
        • ST_MPOINTFROMTEXT
        • ST_MPOLYFROMTEXT
        • ST_POINTFROMTEXT
        • ST_POLYFROMTEXT
    • String Functions
      • ASCII
      • BIN
      • BIT_LENGTH
      • CHAR FUNCTION
      • CHARACTER_LENGTH
      • CHAR_LENGTH
      • CONCAT
      • CONCAT_WS
      • ELT
      • EXPORT_SET
      • FIELD
      • FIND_IN_SET
      • FORMAT
      • FROM_BASE64
      • HEX
      • INSERT FUNCTION
      • INSTR
      • LCASE
      • LEFT
      • LENGTH
      • LIKE
      • LOAD_FILE
      • LOCATE
      • LOWER
      • LPAD
      • LTRIM
      • MAKE_SET
      • MATCH AGAINST
      • MID
      • NOT LIKE
      • NOT REGEXP
      • OCT
      • OCTET_LENGTH
      • ORD
      • POSITION
      • QUOTE
      • REGEXP
      • REGEXP_INSTR
      • REGEXP_LIKE
      • REGEXP_REPLACE
      • REGEXP_SUBSTR
      • REPEAT FUNCTION
      • REPLACE FUNCTION
      • REVERSE
      • RIGHT
      • RPAD
      • RTRIM
      • SOUNDEX
      • SOUNDS LIKE
      • SPACE
      • STRCMP
      • SUBSTR
      • SUBSTRING
      • SUBSTRING_INDEX
      • TO_BASE64
      • TRIM
      • UCASE
      • UNHEX
      • UPPER
      • WEIGHT_STRING
    • Window Functions
      • CUME_DIST
      • DENSE_RANK
      • FIRST_VALUE
      • LAG
      • LAST_VALUE
      • LEAD
      • NTH_VALUE
      • NTILE
      • PERCENT_RANK
      • RANK
      • ROW_NUMBER
    • XML
      • EXTRACTVALUE
      • UPDATEXML
  • Geographic Features
    • GEOMETRY HIERARCHY
    • SPATIAL COLUMNS
    • SPATIAL INDEXES
    • MBR
    • WKT
  • Help Metadata
    • HELP_DATE
    • HELP_VERSION
  • Language Structure
    • FALSE
    • TRUE
  • Loadable Functions
    • CREATE FUNCTION LOADABLE FUNCTION
    • DROP FUNCTION LOADABLE FUNCTION
  • Plugins
  • Prepared Statements
    • DEALLOCATE PREPARE
    • DROP PREPARE
    • EXECUTE STATEMENT
    • PREPARE
  • Replication Statements
    • CHANGE MASTER TO
    • CHANGE REPLICATION FILTER
    • CHANGE REPLICATION SOURCE TO
    • PURGE BINARY LOGS
    • PURGE MASTER LOGS
    • RESET MASTER
    • RESET REPLICA
    • RESET SLAVE
    • SET SQL_LOG_BIN
    • START REPLICA
    • START SLAVE
    • STOP REPLICA
    • STOP SLAVE
  • Storage Engines
  • Table Maintenance
    • ANALYZE TABLE
    • CHECK TABLE
    • CHECKSUM TABLE
    • OPTIMIZE TABLE
    • REPAIR TABLE
  • Transactions
    • BEGIN
    • COMMIT
    • LOCK INSTANCE FOR BACKUP
    • LOCK TABLES
    • RELEASE SAVEPOINT
    • ROLLBACK
    • ROLLBACK TO SAVEPOINT
    • SAVEPOINT
    • SET TRANSACTION
    • START TRANSACTION
    • XA
  • Utility
    • DESC
    • DESCRIBE
    • EXPLAIN
    • HELP STATEMENT
    • USE