今天LEFT JOIN 表,报如下错误: 1267-Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLIC for operation '=')
show variables where Variable_name like 'collation%';
结果:
show create table table_name;
alter table table_name default character set utf8mb4 collate=utf8mb4_general_ci;
ALTER TABLE table_name convert to CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;