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 ......
|