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? -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
