Results 1 to 14 of 14
  1. #1
    Join Date
    Nov 2011
    Posts
    21

    Unanswered: What is the correct syntax for this update set limit

    please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete
    Last edited by fencerenu; 01-08-12 at 20:00.

  2. #2
    Join Date
    Nov 2011
    Posts
    21
    please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete
    Last edited by fencerenu; 01-08-12 at 20:00.

  3. #3
    Join Date
    Nov 2011
    Posts
    21
    please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete
    Last edited by fencerenu; 01-08-12 at 20:00.

  4. #4
    Join Date
    Nov 2011
    Posts
    21
    please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete
    Last edited by fencerenu; 01-08-12 at 20:01.

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you're not allowed to say LIMIT m,n in an UPDATE statement, only LIMIT n
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Nov 2011
    Posts
    21
    please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete
    Last edited by fencerenu; 01-08-12 at 20:01.

  7. #7
    Join Date
    Nov 2011
    Posts
    21
    please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete
    Last edited by fencerenu; 01-08-12 at 20:01.

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    what is the range?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  9. #9
    Join Date
    Nov 2011
    Posts
    21
    please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete
    Last edited by fencerenu; 01-08-12 at 20:01.

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by fencerenu View Post
    there are about 9 million articles and i want to adjust the catid in increments of 100,000.
    two questions

    you want to update every single article to category 1? why? and where in the world did you find time to write nine million articles?

    also, why do you feel you need to do it in increments?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  11. #11
    Join Date
    Nov 2011
    Posts
    21
    please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete
    Last edited by fencerenu; 01-08-12 at 20:01.

  12. #12
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i don't think i can help you any more

    you want to artificially "relate" articles by assigning them randomly in blocks of 100,000

    sounds like you're trying to solve one problem (poor performance) by creating another (relating articles into categories based on their id number or something)

    you still didn't answer my question about where you came up with that many articles in the first place, but don't bother, because i don't think i'm gonna like the answer
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  13. #13
    Join Date
    Nov 2011
    Posts
    21
    please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete
    Last edited by fencerenu; 01-08-12 at 20:01.

  14. #14
    Join Date
    Nov 2011
    Posts
    21
    please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete please delete
    Last edited by fencerenu; 01-08-12 at 20:02.

Posting Permissions

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