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)
mysql --help | findstr Distrib //windows终端
mysql --help | grep Distrib //linux终端
D:\phpStudy\MySQL\bin>mysql --help | findstr Distrib
mysql Ver 14.14 Distrib 5.5.53, for Win32 (AMD64)