Re: [SQL] Edit multiple rows concurrent save

2011-10-08 Thread Jasen Betts
On 2011-09-29, Péter Szabó wrote: > users_has_cards.auctions + users_has_cards.decks never can be higher > then users_has_cards.total. It should be also granted that > users_has_cards.total - users_has_cards.auctions number of cards from > a specific type can be in any decks. > > The deck assembl

[SQL] Edit multiple rows concurrent save

2011-10-01 Thread Péter Szabó
Hi there! I am trying to solve a problem, but I am totally stucked. I have a database with users, cards (260) and decks. The users can have cards (a lot of), their cards can be in different decks or in trade state. I don't want to store the cards one by one, so one user has only one row for a spec

[SQL] Edit multiple rows concurrent save

2011-09-29 Thread Péter Szabó
Hi there! I am trying to solve a problem, but I am totally stucked. I have a database with users, cards (260) and decks. The users can have cards (a lot of), their cards can be in different decks or in trade state. I don't want to store the cards one by one, so one user has only one row for a spec