MySql之变更 CHARACTER和COLLATE

1.schema层面变更

ALTER DATABASE XXXX_db CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

2.表层面变更

ALTER TABLE XXXXX_TBL CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;