select, replace priority

[jackme]

I have a php file with
1. CREATE TEMPORARY TABLE on tableA;
2. REPLACE into tableA;
3. CREATE TEMPORARY TABLE on tableA;
4. REPLACE into tableA;

Can i be sure that the REPLACE in step 2. will be finished before the TEMPORARY table in step 3. is made?

[DR_LaRRY_PEpPeR]

i guess those are just short example queries you have there? anyway, yeah, a query will always been finished before the next one is executed. the only exceptions would be REPLACE DELAYED INTO or INSERT DELAYED INTO, where it's possible, if the server was busy, that the rows wouldn't be inserted yet for the next query. that's because DELAYED returns right away.