SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
Thread: select, replace priority
-
Dec 23, 2001, 12:07 #1
- Join Date
- Jul 2001
- Posts
- 31
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
select, replace priority
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?
-
Dec 23, 2001, 16:23 #2
- Join Date
- Jul 2001
- Location
- Missouri
- Posts
- 3,428
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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.
- Matt** Ignore old signature for now... **
Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
"Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR
Bookmarks