mysql:查询数据库版本的几种方式

 

Mysql版本：

 

登入数据库的时候：

select @@version;

select version();

复制代码
mysql> select @@version;
+-----------+
| @@version |
+-----------+
| 5.5.53    |
+-----------+
1 row in set (0.00 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.5.53    |
+-----------+
1 row in set (0.00 sec)
复制代码

status;

复制代码
mysql> status;
--------------
mysql  Ver 14.14 Distrib 5.5.53, for Win32 (AMD64)

Connection id:          11
Current database:       mysql
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.5.53 MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3306
Uptime:                 3 hours 3 min 4 sec

Threads: 3  Questions: 240  Slow queries: 0  Opens: 49  Flush tables: 1  Open tables: 0  Queries per second avg: 0.021
--------------
复制代码

 

 

未登入数据库的时候：

mysql -V

mysql –version

D:\MySQL\bin>mysql -V
mysql  Ver 14.14 Distrib 5.5.53, for Win32 (AMD64)

D:\MySQL\bin>mysql --version
mysql  Ver 14.14 Distrib 5.5.53, for Win32 (AMD64)

mysql –help | findstr Distrib　　　　//windows终端

mysql –help | grep Distrib　　　　//linux终端

D:\phpStudy\MySQL\bin>mysql --help | findstr Distrib
mysql  Ver 14.14 Distrib 5.5.53, for Win32 (AMD64)
posted on
2018-03-08 16:50 
路修远而求索 
阅读(32895) 
评论(0) 
编辑 
收藏 
举报

版权声明：本文为keyi原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/keyi/p/8529413.html