admin 管理员组

文章数量: 894192

MySql数据库版本查询

MySql版本信息的查询:

 

1、通过mysql -V命令查询

C:/mysql/bin>mysql -V
mysql  Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)

 

2、通过mysql模式下的status命令查看状态

mysql> status
--------------
mysql  Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)

Connection id:          14933
Current database:       mysql
Current user:           root@localhost
SSL:                    Not in use
Server version:         4.0.18-nt
Protocol version:       10
Connection:             localhost via TCP/IP
Client characterset:    latin1
Server characterset:    latin1
TCP port:               3306
Uptime:                 19 hours 24 min 41 sec

Threads: 2  Questions: 37443  Slow queries: 0  Opens: 355  Flush tables: 1  Open
 tables: 9  Queries per second avg: 0.536
--------------

mysql>

 

3、通过mysql模式下的select语句查询

mysql> select version();
+-----------+
| version() |
+-----------+
| 4.0.18-nt |
+-----------+
1 row in set (0.00 sec)

mysql>

 

4、通过mysql --help命令进行查看

C:/mysql/bin>mysql --help
mysql  Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)
Copyright (C) 2002 MySQL AB

......

 

转帖:.html

本文标签: MySql数据库版本查询