RE: Newbie query

2001-11-21 Thread Charles Allen
is correct? Thanks, Charles. -Original Message----- From: Charles Allen [mailto:[EMAIL PROTECTED]] Sent: 21 November 2001 14:29 To: Mysql (E-mail) Subject: Newbie query 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

Newbie query

2001-11-21 Thread Charles Allen
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