《Mysql實(shí)例查看mysql版本的4種方法》要點(diǎn):
本文介紹了Mysql實(shí)例查看mysql版本的4種方法,希望對(duì)您有用。如果有疑問(wèn),可以聯(lián)系我們。
導(dǎo)讀:1:在終端下:mysql -V 查看mysql版本.
[root@jbxue ~]$ mysql -Vmysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i68...
1:在終端下:mysql -V 查看mysql版本.
?MYSQL數(shù)據(jù)庫(kù)
[root@jbxue ~]$ mysql -V
mysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i686)
2:在mysql中:mysql> status;
?MYSQL數(shù)據(jù)庫(kù)
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里面查找
?MYSQL數(shù)據(jù)庫(kù)
[root@jbxue ~]$ mysql --help | grep Distrib
mysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i686)
4:使用mysql的函數(shù)
?MYSQL數(shù)據(jù)庫(kù)
mysql> select version();
+-------------+
| version()?? |
+-------------+
| 3.23.56-log |
+-------------+
1 row in set (0.00 sec)
轉(zhuǎn)載請(qǐng)注明本頁(yè)網(wǎng)址:
http://www.snjht.com/jiaocheng/6474.html