mysql - 面试题：如何把login_log表转换成last_login表？

问题描述

问题解答

如果只是导数据，用下面的SQL就搞定了：

INSERT INTO last_login(user_id,last_login_time,last_login_ip)SELECT log.user_id, log.login_time , log.login_ipFROM login_log log, (SELECT user_id, MAX(login_time) last_login_timeFROM login_logGROUP BY user_id ) last_logWHERE log.user_id= last_log.user_idAND log.login_time= last_log.last_login_time;