標題: 升級錯誤，求解！ [打印本頁] 作者: cqnfym 時間: 2022-12-26 11:22 標題: 升級錯誤，求解！ (1062) Duplicate entry ' ' for key 'username'
ALTER TABLE common_member CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
作者: 湖中沉 時間: 2022-12-26 11:27
進入數據庫，執行語句：
select uid from pre_ucenter_members where username in (select username from pre_ucenter_members group by convert(username using utf8mb4) collate utf8mb4_unicode_ci having count(1) > 1)
再將異常用戶改名
，如果UC表查詢無異常，上述語句中表名可以更換為（pre_common_member）作者: cqnfym 時間: 2022-12-26 12:28
湖中沉 發表于 2022-12-26 11:27
進入數據庫，執行語句：
select uid from pre_ucenter_members where username in (select username from p ...