MySql Error 1093 You can't specify target table 'x' for update in FROM clause

Discussion in 'MySQL' started by Fahd, Apr 23, 2008.

0
  1. #1
    Hi Guys,

    This is what I need to accomplish...

    UPDATE links SET out=out+1 WHERE id = (SELECT id FROM links WHERE url = '$url')
    PHP:
    But mysql gives...

    What is the best alternate way to achieve this?

    Thanks in advance! :)
     
    Fahd, Apr 23, 2008 IP
  2. Petey

    Petey Peon

    Messages:
    68
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Hi Fahd,

    I might be missing something but wouldn't:

    UPDATE links SET out=out+1 WHERE url = '$url'

    work for you?
     
    Petey, Apr 24, 2008 IP
  3. Fahd

    Fahd Well-Known Member

    Messages:
    2,152
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    100
    #3
    Petey,

    You're not missing a damn thing. I'm stupid! :eek:

    Thanks! :)
     
    Fahd, Apr 24, 2008 IP
  4. Petey

    Petey Peon

    Messages:
    68
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Hi Fahd,

    Glad I could help. You're not stupid - a stupid person wouldn't ask for help.

    Petey
     
    Petey, Apr 24, 2008 IP
  5. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #5
    Well said.
     
    mwasif, Apr 24, 2008 IP