修改mysql数据库的表字符集和排序

  • Post author:
  • Post category:mysql


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 版权协议,转载请附上原文出处链接和本声明。