mysql的帮助⽂档_mysql帮助⽂档使⽤mysql有很完善的帮助⽂档，在mysql命令⾏下可以通过？ 或者help 加上命令可以查看改命令的帮助信息，
我们查下⼏个常⽤的help命令
第⼀层帮助信息：
contents;
mysql> ? contents;
You asked for help about help category: "Contents"
For more information, type 'help ', where is one of the following
categories:
Account Management
Administration
Compound Statements
Data Definition
Data Manipulation
Data Types
Functions
Functions and Modifiers for Use with GROUP BY
Geographic Features
Help Metadata
Language Structure
Plugins
Table Maintenance
Transactions
User-Defined Functions
Utility
再查看具体每⼀层的帮助信息
mysql> ? Account Management;
You asked for help about help category: "Account Management"
For more information, type 'help ', where is one of the following
topics:
CREATE USER
DROP USER
REVOKE
SET PASSWORD
mysql> ? Administration
You asked for help about help category: "Administration"
For more information, type 'help ', where is one of the following topics:
BINLOG
CACHE INDEX
CHANGE MASTER TO
DEALLOCATE PREPARE
EXECUTE STATEMENT
FLUSH
FLUSH QUERY CACHE
HELP COMMAND
KILL
LOAD INDEX
PREPARE
PURGE BINARY LOGS
RESET
RESET MASTER
RESET SLAVE
SET
SET GLOBAL SQL_SLAVE_SKIP_COUNTER
SET SQL_LOG_BIN
SHOW
SHOW AUTHORS
SHOW BINARY LOGS
SHOW BINLOG EVENTS
SHOW CHARACTER SET
SHOW COLLATION
SHOW COLUMNS
SHOW CONTRIBUTORS
SHOW CREATE FUNCTION SHOW CREATE PROCEDURE SHOW CREATE TABLE SHOW CREATE TRIGGER SHOW CREATE VIEW
SHOW DATABASES
SHOW ENGINE
SHOW ENGINES
SHOW ERRORS
SHOW EVENTS
SHOW FUNCTION CODE SHOW FUNCTION STATUS SHOW GRANTS
SHOW INDEX
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 SLAVE HOSTS
SHOW SLAVE STATUS SHOW STATUS
SHOW TABLE STATUS SHOW TABLES
SHOW TRIGGERSmysql下载starting the server
SHOW VARIABLES
SHOW WARNINGS
mysql> ? Compound Statements;
You asked for help about help category: "Compound Statements" For more information, type 'help ', where is one of the following topics:
BEGIN END
CASE STATEMENT
CLOSE
DECLARE CONDITION
DECLARE CURSOR
DECLARE HANDLER
DECLARE VARIABLE
FETCH
IF STATEMENT
ITERATE
LEAVE
LOOP
OPEN
REPEAT LOOP
RESIGNAL
RETURN
SELECT INTO
SET VARIABLE
SIGNAL
WHILE
mysql> ? Data Definition;
You asked for help about help category: "Data Definition"
For more information, type 'help ', where is one of the following topics:
ALTER DATABASE
ALTER EVENT
ALTER FUNCTION
ALTER PROCEDURE
ALTER VIEW
CONSTRAINT
CREATE DATABASE
CREATE EVENT
CREATE FUNCTION
CREATE INDEX
CREATE PROCEDURE
CREATE SERVER
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
DROP DATABASE
DROP EVENT
DROP FUNCTION
DROP INDEX
DROP PROCEDURE
DROP SERVER
DROP TABLE
DROP TRIGGER
DROP VIEW
MERGE
RENAME TABLE
TRUNCATE TABLE
这⾥可以根据不同的分类显⽰每个分类下⽀持的mysql指令
mysql> ? START SLAVE;
Name: 'START SLAVE'
Description:
Syntax:
START SLAVE [thread_type [, thread_type] ... ]
START SLAVE [SQL_THREAD] UNTIL
MASTER_LOG_FILE = 'log_name', MASTER_LOG_POS = log_pos START SLAVE [SQL_THREAD] UNTIL

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。