Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    4

    Unanswered: UPDATE using SELECT

    I'm trying to do the following but MySQL is complaining about a syntax error:

    UPDATE `groupmaster`
    SET reccount =
    (SELECT count(ID) FROM `allgroups` WHERE groupname = 'group1')
    WHERE groupname = 'group1'

    What am I doing wrong?

    Thanks
    Al

  2. #2
    Join Date
    May 2004
    Location
    NJ USA
    Posts
    21
    The stable version of mySQL does not support sub-queries....
    J.D.
    Database Administrator

Posting Permissions

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