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？
mysql 如何修改一個table表的排序規則？
慕田峪9158850
2019-03-13 11:30:19
