https://dba.stackexchange.com/questions/170610/how-to-retrieve-the-query-i-used-to-create-a-view SHOW CREATE VIEW not work since it will dump create command within CONVERT() Example: CREATE ALGORITHM=UNDEFINED DEFINER=`user`@`%` SQL SECURITY DEFINER VIEW `ViewFollowAndFollowerCount` AS select `t1`.`user_id` AS `user_id`,`t4`.`user_name` AS `user_name`,`t2`.`followCount` AS `followCount`,`t3`.`followerCount` AS `followerCount`,`t1`.`created_at` AS `follow_created_at` from (((`UserFollowData` `t1` left join `ViewFollowCountGroupByUserId` `t2` on((`t1`.`user_id` = `t2`.`user_id`))) left join `ViewFollowCountGroupByFollowUserId` `t3` on((`t1`.`user_id` = `t3`.`follow_user_id`))) left join `UserData` `t4` on((convert(`t1`.`user_id` using utf8mb4) = `t4`.`user_id`))) I got error something like: "Illegal mix of collations " This caused by CONVERT() on dump /export (?) when convert collation ie. to utf8mb4... Detail here https://bugs.mysql.com/bug.php?id=54278 So to f...
Some tribes of the programmer clan.