库的
ALTER DATABASE pobo_mhall2 CHARACTER SET = utf8 COLLATE = utf8_bin;
表的
ALTER TABLE 表名 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
批量修改表的
SELECT CONCAT('ALTER TABLE ', TABLE_NAME, ' CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;') AS alter_statement
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'pobo_mhall2';