Re: Mod python - mysql lock

2007-03-05 Thread John Nagle
If you use MySQL 5, you get atomic transactions. The old "LOCK" thing is becoming obsolete. Suggest getting a newer MySQL and a newer MySQL book. John Nagle Jan Danielsson wrote: > Roopesh wrote: > >>In my mod_python project I am using mysql as the database.

Re: Mod python - mysql lock

2007-03-05 Thread Jan Danielsson
Roopesh wrote: > In my mod_python project I am using mysql as the database. There is > table card in which unique cards are stored. When a user request comes > he has to get a unique card. In this situation I want to use LOCK with > which I can prevent other users accessing the table. I tried excut