MariaDB - LiveStone/knowledge-base GitHub Wiki

1. Useful commands and queries

Table config info

SHOW TABLE STATUS;

Show DB collation and encoding info

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA;

Change DB collation and encoding info

ALTER DATABASE partsplanet CHARACTER SET = 'utf8mb4' COLLATE = 'utf8mb4_unicode_ci';

Change Table Engine

ALTER TABLE table_name ENGINE=InnoDB;

Show more details on error

SHOW ENGINE INNODB STATUS;

Change Table Collation and Char encoding

alter table <some_table> convert to character set utf8mb4 collate utf8mb4_unicode_ci;

Show global vars

SHOW GLOBAL VARIABLES LIKE '%';

⚠️ GitHub.com Fallback ⚠️