MySQL-show
show提供了数据库、表、列等元数据信息。
show {binary|master} logs
#
show {binary|master} logsSHOW BINLOG EVENTS
SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]SHOW {CHARACTER SET | CHARSET}
SHOW COLLATION [like_or_where]
show [full] columns from <table_name>
SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [like_or_where]show create
查看数据库对象的创建语句。包括数据库、事件、函数、存储过程、表、触发器、视图
# 查看创建ybond库的SQL语句。
show create database <database_name>;
# 查看指定事件的创建语句
show create event <event_name>;
# 查看指定函数的创建语句
show create funciton <func_name>;
#查看指定存储过程的创建语句
show create procedure <proc_name>;
#查看指定表的创建SQL
show create table <table_name>;
#查看指定触发器的创建语句
show create trigger <trigger_name>;
#查看指定视图的创建语句
show create view <view_name>;show databases
#查看当前MySQL服务器有哪些数据库。支持like和where条件
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)`## show engine ##
SHOW ENGINE engine_name {STATUS | MUTEX}
SHOW [STORAGE] ENGINES
show errors
SHOW ERRORS [LIMIT [offset,] row_count]
show events
show function
SHOW FUNCTION CODE func_name
SHOW FUNCTION STATUS [like_or_where]
SHOW GRANTS FOR user
SHOW INDEX FROM tbl_name [FROM db_name]
SHOW MASTER STATUS
SHOW OPEN TABLES [FROM db_name] [like_or_where]
SHOW PLUGINS
SHOW PROCEDURE CODE proc_name
SHOW PROCEDURE STATUS [like_or_where]
SHOW PRIVILEGES
SHOW [FULL] PROCESSLIST
SHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n]
SHOW PROFILES
SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
SHOW SLAVE HOSTS
SHOW SLAVE STATUS [FOR CHANNEL channel]
SHOW [GLOBAL | SESSION] STATUS [like_or_where]
SHOW TABLE STATUS [FROM db_name] [like_or_where]
SHOW [FULL] TABLES [FROM db_name] [like_or_where]
SHOW TRIGGERS [FROM db_name] [like_or_where]
show variables
查看系统变量。支持like和where条件。
SHOW [GLOBAL | SESSION] VARIABLES [like_or_where]
- global 全局
- session 会话
SHOW WARNINGS [LIMIT [offset,] row_count]
评论已关闭