Stephan Beal wrote: > On Fri, Oct 25, 2013 at 12:51 PM, Clemens Ladisch <clem...@ladisch.de>wrote: >> CREATE TEMP TABLE t(playerid, leagueid, auto_rank INTEGER PRIMARY KEY); >> INSERT INTO t(playerid, leagueid) SELECT players.playerid, %d FROM ...; >> INSERT INTO leagueplayers(playerid, leagueid, current_rank, original_rank) >> SELECT playerid, leagueid, auto_rank, auto_rank FROM t; >> DROP TABLE t; > > That will lead to dupe IDs on subsequent transactions, won't it?
The OP asked for "rank" values beginning at 1. It's a one-time schema conversion. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
