SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    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?

  2. #2
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •