mysql体系信息函数有:1、运用【SHOW PROCESSLIST】敕令输出当前用户的衔接信息;2、 运用【CHARSET()】函数返回字符串运用的字符集;3、运用【COLLATION()】函数返回字符串分列体式格局。
mysql体系信息函数有:
一、检察当前MySQL版本号
mysql> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 5.7.22 |
+-----------+
1 row in set (0.00 sec)
相干进修引荐:mysql视频教程
二、检察当前用户的衔接数
mysql> SELECT CONNECTION_ID();
+-----------------+
| CONNECTION_ID() |
+-----------------+
| 2 |
+-----------------+
1 row in set (0.00 sec)
三、运用SHOW PROCESSLIST敕令输出当前用户的衔接信息
mysql> SHOW PROCESSLIST;
+----+------+------+------+---------+------+----------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+------+------+---------+------+----------+------------------+
| 2 | root | | test | Query | 0 | starting | SHOW PROCESSLIST |
+----+------+------+------+---------+------+----------+------------------+
1 row in set (0.00 sec)
四、检察当前运用的数据库
mysql> SELECT DATABASE(),SCHEMA();
+------------+----------+
| DATABASE() | SCHEMA() |
+------------+----------+
| test | test |
+------------+----------+
1 row in set (0.00 sec)
五、猎取当前登录用户称号
mysql> SELECT USER(), CURRENT_USER(), SYSTEM_USER();
+--------+-----------------------------------+---------------+
| USER() | CURRENT_USER() | SYSTEM_USER() |
+--------+-----------------------------------+---------------+
| root@ | skip-grants user@skip-grants host | root@ |
+--------+-----------------------------------+---------------+
1 row in set (0.00 sec)
六、 运用CHARSET()函数返回字符串运用的字符集
SELECT CHARSET('abc'),
CHARSET(CONVERT('abc' USING latin1)),
CHARSET(VERSION());
+----------------+--------------------------------------+--------------------+
| CHARSET('abc') | CHARSET(CONVERT('abc' USING latin1)) | CHARSET(VERSION()) |
+----------------+--------------------------------------+--------------------+
| utf8 | latin1 | utf8 |
+----------------+--------------------------------------+--------------------+
1 row in set (0.00 sec)
七、运用COLLATION()函数返回字符串分列体式格局
mysql> SELECT COLLATION('abc'),COLLATION(CONVERT('abc' USING utf8));
+------------------+--------------------------------------+
| COLLATION('abc') | COLLATION(CONVERT('abc' USING utf8)) |
+------------------+--------------------------------------+
| utf8_general_ci | utf8_general_ci |
+------------------+--------------------------------------+
1 row in set (0.00 sec)
八、运用SELECT LAST_INSERT_ID检察末了一个自动生成的列值
1、一次插进去一条纪录
(1)、起首建立表worker,其Id字段带有AUTO_INCREMENT束缚
CREATE TABLE worker (Id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
Name VARCHAR(30));
Query OK, 0 rows affected (0.23 sec)
(2)、离别零丁向表worker中插进去2条纪录:
mysql> INSERT INTO worker VALUES(NULL, 'jimy');
Query OK, 1 row affected (0.03 sec)
mysql> INSERT INTO worker VALUES(NULL, 'Tom');
Query OK, 1 row affected (0.02 sec)
mysql> SELECT * FROM worker;
+----+------+
| Id | Name |
+----+------+
| 1 | jimy |
| 2 | Tom |
+----+------+
2 rows in set (0.00 sec)
(3)、检察已插进去的数据能够发明,末了一条插进去的纪录的Id字段值为2,运用LAST_INSERT_ID()检察末了自动生成的Id值:
mysql> SELECT LAST_INSERT_ID();
+------------------+
| LAST_INSERT_ID() |
+------------------+
| 2 |
+------------------+
1 row in set (0.01 sec)
2、一次同时插进去多条纪录
(1)、接下来,向表中插进去多条纪录
INSERT INTO worker VALUES
(NULL, 'Kevin'),(NULL,'Michal'),(NULL,'Nick');
Query OK, 3 rows affected (0.03 sec)
Records: 3 Duplicates: 0 Warnings: 0
(2)、查询已插进去的的纪录,
mysql> SELECT * FROM worker;
+----+--------+
| Id | Name |
+----+--------+
| 1 | jimy |
| 2 | Tom |
| 3 | Kevin |
| 4 | Michal |
| 5 | Nick |
+----+--------+
5 rows in set (0.00 sec)
mysql> SELECT LAST_INSERT_ID();
+------------------+
| LAST_INSERT_ID() |
+------------------+
| 3 |
+------------------+
1 row in set (0.00 sec)
以上就是mysql体系信息函数有哪些?的细致内容,更多请关注ki4网别的相干文章!
收藏 | 0