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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Get a FREE online virus check for your PC here, from McAfee. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]