version - xiaoboluo768/mysql-system-schema GitHub Wiki

• 查看当前的sys schema和MySQL server版本，数据来源：select '1.5.1'常数查询和version()函数输出

• version视图字段含义如下

  • sys_version：sys schema版本
  • mysql_version：MySQL server版本

• 视图定义语句

CREATE OR REPLACE
  DEFINER = 'root'@'localhost'
  SQL SECURITY INVOKER
VIEW version (
  sys_version,  mysql_version
) AS
SELECT '1.5.1' AS sys_version,
        version() AS mysql_version;

• 视图查询信息示例

admin@localhost : sys 12:57:53> select * from version;
+-------------+---------------+
| sys_version | mysql_version |
+-------------+---------------+
| 1.5.1      | 5.7.18-log    |
+-------------+---------------+
1 row in set (0.00 sec)

• 参考链接：https://dev.mysql.com/doc/refman/5.7/en/sys-version.html

---

上一篇： user_summary_by_statement_type,x$user_summary_by_statement_type视图 |

下一篇： wait_classes_global_by_avg_latency,x$wait_classes_global_by_avg_latency视图