mysql的帮助文档_mysql帮助文档使用

更新时间:2023-07-26 19:43:15 阅读: 评论:0

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 U with GROUP BY
Geographic Features
Help Metadata
Language Structure
Plugins
Table Maintenance
Transactions
Ur-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 TRIGGERS
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

本文发布于:2023-07-26 19:43:15,感谢您对本站的认可!

本文链接:https://www.wtabcd.cn/fanwen/fan/82/1118716.html

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

标签:命令   帮助   电影   教师队伍   管理   蒙特
相关文章
留言与评论(共有 0 条评论)
   
验证码:
推荐文章
排行榜
Copyright ©2019-2022 Comsenz Inc.Powered by © 专利检索| 网站地图