纳速健身

标题: MySql数据库版本查询 [打印本页]

作者: awagink 时间: 2014-9-6 22:38
标题: 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

......

欢迎光临纳速健身 (https://nasue.com/)