Mike,
Use the following statement....
UPDATE COUNTER SET HITS = HITS + 1 WHERE keyvalue='69';
Further examples may be found using the link to the mysql manual below.
Have a nice Day!
D. Grubb.
----- Original Message -----
From: Mike Podlesny <[EMAIL PROTECTED]>
To: mySQL Mailing List <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 3:15 PM
Subject: Help with an SQL statement
> Thanks for everyone's help with the dat question now I would like to know
if
> someone could help me with another question.
>
> I have a table called COUNTER and a field in the table called HITS in an
SQL
> statement I would like to update this field by adding 1 to it's current
> value any ideas?
>
> Thanks,
> Mike
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php