mysql中查看_MySQL中查看MySQL相关信息

(1)VERSION()返回数据库版本号

mysql> select VERSION();

+-----------+

| VERSION() |

+-----------+

| 5.5.8-log |

+-----------+

1 row in set (0.00 sec)

(2)CONNECTION_ID()返回数据库的连接次数

mysql> select CONNECTION_ID();

+-----------------+

| CONNECTION_ID() |

+-----------------+

|              40 |

+-----------------+

1 row in set (0.02 sec)

(3)DATABASE()、SCHEMA()返回当前数据库名

mysql> select DATABASE(), SCHEMA();

+------------+----------+

| DATABASE() | SCHEMA() |

+------------+----------+

| test       | test     |

+------------+----------+

1 row in set (0.00 sec)

mysql>

(4)USER()、SYSTEM_USER()、SESSION_USER()返回当前用户

mysql> select USER(), SYSTEM_USER(), SESSION_USER();

+----------------+----------------+----------------+

| USER()         | SYSTEM_USER()  | SESSION_USER() |

+----------------+----------------+----------------+

| root@localhost | root@localhost | root@localhost |

+----------------+----------------+----------------+

1 row in set (0.00 sec)

mysql>

(5)CURRENT_USER()、CURRENT_USER返回当前用户

mysql> select CURRENT_USER(), CURRENT_USER;

+----------------+----------------+

| CURRENT_USER() | CURRENT_USER   |

+----------------+----------------+

| root@localhost | root@localhost |

+----------------+----------------+

1 row in set (0.00 sec)

mysql>

(6)CHARSET(str)返回字符串str的字符集

mysql> select CHARSET('MySQL');

+------------------+

| CHARSET('MySQL') |

+------------------+

| utf8             |

+------------------+

1 row in set (0.00 sec)

mysql>

(7)COLLATION(str)返回字符串str的字符排列方式

mysql> select COLLATION('MySQL');

+--------------------+

| COLLATION('MySQL') |

+--------------------+

| utf8_general_ci    |

+--------------------+

1 row in set (0.00 sec)

mysql>