系統

MySQL 系統

Categories:

Tags:

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