MySQL排序规则不一致导致的Select异常

报错详情

Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='

引发原因

表A的排序规则为：utf8mb4_general_ci
表B的排序规则为：utf8mb4_0900_ai_ci

解决方案

# 将表A的排序规则变更为 utf8mb4_0900_ai_ci
ALTER TABLE A CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;