02.MySQL基本指令

MySQL提示符

\D  日期
\h  主机名
\u  用户名
\d  当前数据库名称

规范：

关键字函数名大写
数据库名，表名，字段名小写
MySQL语句一般以分号结尾

版本号 -V(–version)

C:\Users\Administrator>mysql -V
mysql  Ver 14.14 Distrib 5.7.22, for Win64 (x86_64)

登陆 -u(–user=name) -p(–password[=name]) -P(-port=#) -h(host=name)

C:\Users\Administrator>mysql -u root -p -P3306 -h127.0.0.1
Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.22 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

退出\q(exit或quit)

mysql> \q
Bye

自定义提示符（此处为toly>） –prompt

C:\Users\Administrator>mysql -uroot -ptoly  --prompt toly
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.7.22 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

toly>

也可登陆后修改

mysql> prompt toly>
PROMPT set to 'toly>'
toly>

当前版本号、日期、时间、用户

mysql> SELECT VERSION(), CURRENT_DATE,NOW(),USER();
+-----------+--------------+---------------------+----------------+
| VERSION() | CURRENT_DATE | NOW()               | USER()         |
+-----------+--------------+---------------------+----------------+
| 5.7.22    | 2018-05-10   | 2018-05-10 12:30:26 | root@localhost |
+-----------+--------------+---------------------+----------------+
1 row in set (0.00 sec)

简单计算

mysql> SELECT 1+1, (4+1)*5;
+-----+---------+
| 1+1 | (4+1)*5 |
+-----+---------+
|   2 |      25 |
+-----+---------+
1 row in set (0.00 sec)

展示数据库

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

转载于:https://www.cnblogs.com/toly-top/p/9782034.html