1,在mysql中:mysql> status;
mysql> status;
--------------
C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe Ver 14.14 Distrib 5.6.24, for Win32 (x86)
Connection id: 8
Current database: information_schema
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.6.24-log 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: 11 hours 14 min 37 sec
Threads: 1 Questions: 1065 Slow queries: 0 Opens: 95 Flush tables: 1 Open tables: 74 Queries per second avg: 0.026
--------------
2,使用mysql的函数,以下是代码片段:mysql> select version();
mysql> select version();
+------------+
| version() |
+------------+
| 5.6.24-log |
+------------+
1 row in set (0.05 sec)