Re: [sqlite] creating teams with random players

2009-12-16 Thread Simon Slavin
On 16 Dec 2009, at 5:32pm, Robert Citek wrote: > I can adjust the table to pick 6 random players by including > another column that holds a random integer: > > $ sqlite3 -init <( echo ' > alter table pool add tag INTEGER > ; > update pool set tag=random() After that UPDATE (that should be faste

[sqlite] creating teams with random players

2009-12-16 Thread Robert Citek
Hello all, I have a toy problem which is analogous to a real problem I am working on. The toy problem is, given a set of teams each with a roster of 100 possible players, create a set of teams each with 6 players chosen randomly from the roster of 100 players. I can model the sets in sqlite3 and