控制台设置中文乱码问题:charset gbk;
控制台导出数据库:>mysqldump -u root -p activity >d:\\activity.sql
Activity项目》查询活动达人实例:SELECT use_id FROM userinfo WHERE use_id in( SELECT foc_user_id FROM (SELECT * FROM focus GROUP BY foc_user_id ORDER BY count(foc_user_id) DESC LIMIT 0,6)as t);
Activity项目》根据关注的用户 查询出其信息: SELECT use_id FROM userinfo WHERE use_id in( SELECT foc_user_id FROM focus WHERE user_id=1 ORDER BY foc_time DESC );