系统
MySQL 系统
Categories:
MySQL 版本
show variables like '%version%';
MySQL Plugin 外挂
SHOW PLUGINS;
SELECT PLUGIN_NAME as Name, PLUGIN_VERSION as Version, PLUGIN_STATUS as Status
FROM INFORMATION_SCHEMA.PLUGINS
WHERE PLUGIN_TYPE='STORAGE ENGINE';
资料库编码
use <DATABASE_NAME>
SELECT @@character_set_database, @@collation_database;
SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME
FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '<DATABASE_NAME>';
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA;
SHOW TABLE STATUS FROM <DATABASE_NAME>;
Reference
- How to Check MySQL Version via The Command Line - Knowledge base - ScalaHosting
- 简单使用 Mysql Partition 优化查询 - 工作玩乐实验室
- MySQL :: MySQL 8.0 Reference Manual :: 10.3.3 Database Character Set and Collation
- Show the character set and the collation of your MySQL tables - makandra dev