Wait for 4.1, it will have multi-table updates in it. Until then, you'll have to use two separate queries.
Steve On Wed, 2001-11-21 at 07:28, Charles Allen wrote: > Hi, > > A v. basic question from a mySql newbie: > > I want to update a table based on the contents of another table. The SQL I > am trying to execute is: > > "update servers set servers.responsecount=servers.responsecount+1 where > servers.gameid = lastsnapshot.gameid;" > ie: Increment a responsecount for rows where the gameid in the servers table > matches the gameid in the lastsnapshot table. I am getting a "Unknown table > lastsnapshot" error from mySql. Can someone point me in the right direction > for this. > > Thanks, > > Charles. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php