RE: Simultaneous SELECT and UPDATE on the same table

Hi there, On Fri, 8 Mar 2002, Paul DuBois wrote: > At 21:14 +0100 3/8/02, Roger Baklund wrote: > >* Paul DuBois > >> At 17:00 + 3/8/02, Corin Hartland-Swann wrote: > >[...] > >> >This works for a varying number of rows (usually 5,000 to 10,000) before > >> >it silently exits the loop. I'

RE: Simultaneous SELECT and UPDATE on the same table

At 21:14 +0100 3/8/02, Roger Baklund wrote: >* Paul DuBois >> At 17:00 + 3/8/02, Corin Hartland-Swann wrote: >[...] >> >This works for a varying number of rows (usually 5,000 to 10,000) before >> >it silently exits the loop. I'm using MySQL 3.23.49a >[...] >> >> That's also your problem.

RE: Simultaneous SELECT and UPDATE on the same table

* Paul DuBois > At 17:00 + 3/8/02, Corin Hartland-Swann wrote: [...] > >This works for a varying number of rows (usually 5,000 to 10,000) before > >it silently exits the loop. I'm using MySQL 3.23.49a [...] > > That's also your problem. With mysql_use_result, it's *required* > that you compl

Re: Simultaneous SELECT and UPDATE on the same table

At 17:00 + 3/8/02, Corin Hartland-Swann wrote: >Hi there, > >I have a medium-size table (3 million rows) with several pieces of data >including an ID and a number (called id and num below). I have a program >which builds a hash in perl from a data file of the 'new' numbers for each >id, only s

Simultaneous SELECT and UPDATE on the same table

Hi there, I have a medium-size table (3 million rows) with several pieces of data including an ID and a number (called id and num below). I have a program which builds a hash in perl from a data file of the 'new' numbers for each id, only some of which have changed (5-10%). To update the table