修改MySQL数据库编码

2024-03-18  本文已影响0人  King斌
ALTER DATABASE 数据库名称  CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

SELECT CONCAT('ALTER TABLE ', table_name, ' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;') AS alter_sql
FROM information_schema.tables
WHERE table_schema = '数据库名称 ';
上一篇 下一篇

猜你喜欢

热点阅读