Mysql 查看数据库版本
查看Mysql版本的两种方式:
一、登入数据库的时候:
select @@version;
select version();
mysql> select @@version; +-----------+ | @@version | +-----------+ | 5.5.53 | +-----------+ 1 row in set (0.00 sec) mysql> select version(); +-----------+ | version() | +-----------+ | 5.5.53 | +-----------+ 1 row in set (0.00 sec)
status;
mysql> status; -------------- mysql Ver 14.14 Distrib 5.5.53, for Win32 (AMD64) Connection id: 11 Current database: mysql Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 5.5.53 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: 3 hours 3 min 4 sec Threads: 3 Questions: 240 Slow queries: 0 Opens: 49 Flush tables: 1 Open tables: 0 Queries per second avg: 0.021 --------------
二、未登入数据库的时候:
mysql -V
mysql --version
D:\MySQL\bin>mysql -V mysql Ver 14.14 Distrib 5.5.53, for Win32 (AMD64) D:\MySQL\bin>mysql --version mysql Ver 14.14 Distrib 5.5.53, for Win32 (AMD64)
0
赞
热门推荐
-
2、 - 优质文章
-
3、 gate.io
-
8、 golang
-
9、 openharmony
-
10、 Vue中input框自动聚焦