Re: mysql adding
| From: | Hans Lellelid | Date: | Fri, 04 Jun 2004 20:48:01 +0000 |
| Subject: | Re: mysql adding | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34649@lists.php.net to get a copy of this message | ||
Steven Morgan wrote:
is there anyway to add 1 to an int with 1 mysql query, i know i can pull the value down with a SELECT then add 1 with php.. then do an UPDATE on it.. but i didn't know if there was any other way?Do you mean this: UPDATE tablename SET intcol = intcol + 1 ? Hans