alter table application_detail CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
如果需要批量修改:
SELECT CONCAT('ALTER TABLE ', table_name, ' CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;')
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'databaseName';
版权声明:本文为u011649691原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。