公共指令
-
\q
/exit
/quit
, 退出mysql。对于exit
/quit
/\q
加不加;
都可以 -
\c
, 终止命令(是在这条命令还未运行之前) -
\G
,按行显示。注: 最好末尾不要加;
-
\s
/status
,当前mysql
状态信息(版本、字符集等。\s
最好不要加;
status
加不加;
都可以 -
show variables like '%char%'
,查看当前MySQL字符集、
获取服务器元数据
select user();
,返回服务器版本信息select database();
,返回当前数据库名(或空)select version();
,返回当前用户名show status;
,返回服务器状态show variables;
,返回服务器配置变量
帮助命令
help
例如:
help create
mysql> help create
Many help items for your request exist.
To make a more specific request, please type 'he
where <item> is one of the following
topics:
CREATE DATABASE
CREATE EVENT
CREATE FUNCTION
CREATE FUNCTION UDF
CREATE INDEX
CREATE LOGFILE GROUP
CREATE PROCEDURE
CREATE RESOURCE GROUP
CREATE ROLE
CREATE SERVER
CREATE SPATIAL REFERENCE SYSTEM
CREATE TABLE
CREATE TABLESPACE
CREATE TRIGGER
CREATE USER
CREATE VIEW
SHOW
SHOW CREATE DATABASE
SHOW CREATE EVENT
SHOW CREATE FUNCTION
SHOW CREATE PROCEDURE
SHOW CREATE TABLE
SHOW CREATE USER
SPATIAL
mysql>
再例如:
help create database
mysql> help create database
Name: 'CREATE DATABASE'
Description:
Syntax:
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
[create_specification] ...
create_specification:
[DEFAULT] CHARACTER SET [=] charset_name
| [DEFAULT] COLLATE [=] collation_name
CREATE DATABASE creates a database with the given name. To use this
statement, you need the CREATE privilege for the database. CREATE
SCHEMA is a synonym for CREATE DATABASE.
URL: http://dev.mysql.com/doc/refman/8.0/en/create-database.html
mysql>