mysql修改命令
2020-04-29 10
ALTER TABLE `b_comments` DEFAULT CHARACTER SET utf8mb4;
更改表编码
ALTER TABLE b_comments CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
将数据库和已经建好的表也转换成utf8mb4
更改数据库编码：ALTER DATABASE db_name CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
更改表编码：ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;