List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 2 2000 11:42pm
Subject:Re: Adding 1 to a column value
View as plain text  
At 5:13 PM -0500 11-02-2000, Jimmy Gendron wrote:
>Hello all!
>
>I try to add 1 to hits column in the contest table. But its not working...i
>don't know why..here is my code:
>
>mysql> ALTER TABLE contest MODIFY hits INT(32) NOT NULL;
>Query OK, 0 rows affected (0.00 sec)
>Records: 0  Duplicates: 0  Warnings: 0
>
>mysql> UPDATE contest SET hits=hits+1;
>Query OK, 0 rows affected (0.00 sec)
>Rows matched: 0  Changed: 0  Warnings: 0
>
>mysql> select hits from contest;
>Empty set (0.00 sec)
>
>Anyone can help me???
>
>Thank you in advance!!
>
>Jimmy

Looks like your table is empty.  What rows do you expect it to modify?

-- 
Paul DuBois, paul@stripped
Thread
HP UX 10.20 Install ProblemsBill Hess2 Nov
  • Adding 1 to a column valueJimmy Gendron3 Nov
    • Re: Adding 1 to a column valuePaul DuBois3 Nov
  • Re: HP UX 10.20 Install ProblemsJerome Abela16 Nov
RE: Adding 1 to a column valueQuentin Bennett3 Nov
RE: Adding 1 to a column valueNoel Clarkson3 Nov