需求
现在需要把 log_1表和log_2表合并在新创建一个log_3表进行排序
表结构
log_1,log_2,log_3表结构相同,只贴一个表结构
CREATE TABLE log_1
(
id
int(10) unsigned NOT NULL AUTO_INCREMENT,
uid
int(10) NOT NULL,
username
varchar(32) NOT NULL COMMENT ‘用户昵称’,
lastupdate
int(10) unsigned NOT NULL COMMENT ‘最后操作时间’,
PRIMARY KEY (id
) USING BTREE,
KEY uid
(uid
,lastupdate
) USING BTREE,
KEY lastupdate
(lastupdate
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
操作
1.把 log_1表合并到log_2表中
INSERT INTO log_2 ( uid
, username
, lastupdate
) SELECT uid
, username
,lastupdate
from log_1
2.把合并完成到 log_2表的数据重新排序到log_3表中
按照操