I would like to increment the current value of a field X without
having to retrieve field X beforehand. Can I do this?
Example:
UPDATE my_table set field_1 = (current_field_value -1) WHERE...blah,
blah, blah
==
A. Justin Turner
--
PHP
How can I do this?
Bastien Koert wrote:
yes
From: Justin Turner [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] adding to the current value
Date: Thu, 29 Sep 2005 16:26:00 -0400
I would like to increment the current value of a field X without
having to retrieve field X
messing with a production
system, you could always just try out simple stuff like this on your own and
see what happens. More fun that way anyhow.
Rich
-Original Message-
From: Justin Turner [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 29, 2005 5:04 PM
To: Bastien Koert
Cc: php-db
I have tried several times to create a user that has the ability to lock
and unlock tables, but to no avail. Am I missing something? I tried
creating a user with all privileges to a database and still the user
does not have the ability to lock/unlock tables within that database.
GRANT ALL