Re: Mysql isnt keeping up.

[Dan Nelson]

In the last episode (Oct 17), Jeremiah J. Cassidy said:
> If I do the following sequence:
> INSERT
> SELECT
> INSERT
> SELECT
> INSERT
> SELECT
> 
> how do I make sure that the SELECTs are an accurate representation of
> the data that I just INSERTed?
> 
> After the first INSERT, the first few SELECTs don't reflect the fact
> that the INSERT took place.

Chances are your indexes are corrupt and messing up your SLEECTs. As
long as you're not doing INSERT DELAYED, the record should be updated
before the INSERT returns control back to your program.

-- 
	Dan Nelson
	dnelson@stripped