update statement

Discussion in 'Databases' started by prasath_s01, Sep 4, 2008.

  1. #1
    hi,
    i need to write an update script that won't update more then 500 at a time with a break of 20 seconds between each load...
     
    prasath_s01, Sep 4, 2008 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Create a for/while loop and use LIMIT 500 in the UPDATE statement. At the end of for/while, add sleep(20).
     
    mwasif, Sep 6, 2008 IP