mysql 如何修改一个table表的排序规则？

Question

mysql> select `books`.*, `csessioninfo`.`user_info` from `books` inner join `csessioninfo` on `books`.`openid` = `csessioninfo`.`open_id`
    -> ;
ERROR 1267 (HY000): Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='

books 表报错，我该如何将排序规则改为utf8mb4_unicode_ci？

Answer 1

如果是修改一个表的字符集的话，用这个去试试alter table books convert to character set utf8mb4_unicode_ci;