INSERT
INTO
last_login(user_id,last_login_time,last_login_ip)
SELECT
log.user_id,
log.login_time ,
log.login_ip
FROM
login_log log,
(
SELECT
user_id,
MAX(login_time) last_login_time
FROM
login_log
GROUP BY
user_id
) last_log
WHERE
log.user_id= last_log.user_id
AND log.login_time= last_log.last_login_time;
0 
1
460
收藏
如果只是导数据，用下面的SQL就搞定了：