需要把表1的数据转移到表2,只需一个SQL语句:
INSERT INTO ScoreHistory (id, UserId, Score, Time) SELECT id, UserId, Score, Time FROM TMP_ScoreHistory WHERE id <= 20000
需要把表1的数据转移到表2,只需一个SQL语句:
INSERT INTO ScoreHistory (id, UserId, Score, Time) SELECT id, UserId, Score, Time FROM TMP_ScoreHistory WHERE id <= 20000