《Mysql必讀Linux系統下查看mysql版本的四種方法》要點:
本文介紹了Mysql必讀Linux系統下查看mysql版本的四種方法,希望對您有用。如果有疑問,可以聯系我們。
MYSQL必讀1:在終端下:mysql -V. 以下是代碼片段:
代碼如下:
[shengting@login ~]$ mysql -V
mysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i686)
2:在mysql中:mysql> status;
以下是代碼片段:
代碼如下:
mysql> status;
--------------
mysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i686)
Connection id:????????? 416
SSL:??????????????????? Not in use
Current pager:????????? stdout
Using outfile:????????? ''
Using delimiter:??????? ;
Server version:???????? 3.23.56-log
Protocol version:?????? 10
Connection:???????????? Localhost via UNIX socket
Client characterset:??? latin1
Server characterset:??? latin1
UNIX socket:??????????? /tmp/mysql_3311.sock
Uptime:???????????????? 62 days 21 hours 21 min 57 sec
Threads: 1 Questions: 584402560 Slow queries: 424 Opens: 59664208 Flush tables: 1 Open tables: 64 Queries per second avg: 107.551
3:在help里面查找
以下是代碼片段:
代碼如下:
[shengting@login ~]$ mysql --help | grep Distrib
mysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i686)
4:使用mysql的函數
以下是代碼片段:
代碼如下:
mysql> select version();
+-------------+
| version()?? |
+-------------+
| 3.23.56-log |
+-------------+
1 row in set (0.00 sec)
轉載請注明本頁網址:
http://www.snjht.com/jiaocheng/1685.html