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

相关资源：JAVA上百实例源码以及开源项目