I know that. I'm lookign for mysql function that will increment the value.
Tobias gave you the correct answer. His answer achieves the objective you stated in your original message.
Any particular reason you don't want to do what he says?
From: Tobias Asplund <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Mike Mapsnac <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: Increment value Date: Tue, 20 Jan 2004 23:36:22 +0100 (CET)
On Tue, 20 Jan 2004, Mike Mapsnac wrote:
In the table value login_count is int(4). For example if value login_count equal to 3 and each time user login I want to increment by one.
update customer set login_count='how?" where id=12121212;
SET login_count = login_count + 1
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
